用户修改资料不能提交到数据库中,大家看看代码,怎么改?各位帮忙,谢了.
protected void btnCommit_Click(object sender, EventArgs e)
{
string sql = "Update [User] Set UserTrueName=@userTrueName,Sex=@sex,Age=@age,Marry=@marry,IDcard=@idCard,Mobile=@mobile,QQ=@qq,[E-Mail]=@email Where UserName= ' " + Request.Cookies[ "cookieUserName "].Value.Trim() + " ' ";
string connStr = ConfigurationManager.ConnectionStrings[ "dbcon "].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add( "@userTrueName ", SqlDbType.Char, 20);
cmd.Parameters.Add( "@sex ", SqlDbType.Char, 4);
cmd.Parameters.Add( "@age ", SqlDbType.Int, 4);
cmd.Parameters.Add( "@marry ", SqlDbType.Char, 8);
cmd.Parameters.Add( "@idCard ", SqlDbType.Char, 18);
cmd.Parameters.Add( "@mobile ", SqlDbType.Char, 16);
cmd.Parameters.Add( "@qq ", SqlDbType.Real, 12);
cmd.Parameters.Add( "@email ", SqlDbType.Char, 40);
if (tbtruename.Text != null && tbtruename.Text != string.Empty)
{
cmd.Parameters[ "@userTrueName "].Value = tbtruename.Text;
}
else
{
cmd.Parameters[ "@userTrueName "].Value = " ";
}
cmd.Parameters[ "@sex "].Value = rblistsex.Text;
if (tbage.Text != null && tbage.Text != string.Empty)
{
cmd.Parameters[ "@age "].Value = Int32.Parse(tbage.Text);
}
else
{
cmd.Parameters[ "@age "].Value = 0;
}
cmd.Parameters[ "@marry "].Value = ddlistmar.Text;
if (tbidcard.Text != null && tbidcard.Text != string.Empty)
{
cmd.Parameters[ "@idCard "].Value = tbidcard.Text;
}
else
{
cmd.Parameters[ "@idCard "].Value = 0;
}
if (tbmobile.Text != null && tbmobile.Text != string.Empty)
{
cmd.Parameters[ "@mobile "].Value = tbmobile.Text;
}
else
{
cmd.Parameters[ "@mobile "].Value = " ";
}
if (tbqq.Text != null && tbqq.Text != string.Empty)
{
cmd.Parameters[ "@qq "].Value = Decimal.Parse(tbqq.Text);
}
else
{
cmd.Parameters[ "@qq "].Value = 0;
}
if (tbemail.Text != null && tbemail.Text != string.Empty)
{
cmd.Parameters[ "@email "].Value = tbemail.Text;
}
else
{
cmd.Parameters[ "@email "].Value = " ";
}
cmd.ExecuteNonQuery();
Response.Write( " <script language= 'javascript '> alert( '资料更新成功! ') </script> ");
}
[解决办法]
设断点，调试……
[解决办法]
应该不是if(!IsPostback)的问题
楼主是button_Click事件，不知道楼主运行后是什么情况呢？
还有，你的conn.Close()呢？
[解决办法]
把代码用 TRY CATCH括起来
断点跟下就知道了
