做了个更新,但是更新不了数据库,断点设置能执行,又找不出错在哪里。郁闷啊!!!
class user代码为:
public int UpdateUserPartPim(int userid, string realname, string sex, string grade, string sclass, string province, string county, string address, string sectionnum, string phone, string email)
{
SqlConnection myCon = new SqlConnection(
ConfigurationManager.ConnectionStrings["mySQLcon"].ConnectionString); string cmdText = "update users set realname='" + realname + "',sex ='" + sex + "',grade = '" + grade + "',class ='" + sclass + "',province ='" + province + "',county ='" + county + "',address ='" + address + "',sectionnum='" + sectionnum + "',phone ='" + phone + "',email ='" + email + "'where userid ='"+ userid.ToString()+"'";
SqlCommand myCmd = new SqlCommand(cmdText,myCon);
int nresult = -1; myCon.Open(); nresult = myCmd.ExecuteNonQuery;
myCon.Close();
return nresult; }引用文件的代码为:
protected void enterbtn_Click(object sender, EventArgs e)
{
User user = new User();
user.UpdateUserPartPim(userid, realname.Text.Trim(), sex.SelectedValue, grade.Text.Trim(), sclass.Text.Trim(), province.Text.Trim(), county.Text.Trim(), address.Text.Trim(), sectionnum.Text.Trim(), phone.Text.Trim(), email.Text.Trim());
Response.Redirect("userpartpim.aspx");
}
class user代码为:
public int UpdateUserPartPim(int userid, string realname, string sex, string grade, string sclass, string province, string county, string address, string sectionnum, string phone, string email)
{
SqlConnection myCon = new SqlConnection(
ConfigurationManager.ConnectionStrings["mySQLcon"].ConnectionString); string cmdText = "update users set realname='" + realname + "',sex ='" + sex + "',grade = '" + grade + "',class ='" + sclass + "',province ='" + province + "',county ='" + county + "',address ='" + address + "',sectionnum='" + sectionnum + "',phone ='" + phone + "',email ='" + email + "'where userid ='"+ userid.ToString()+"'";
SqlCommand myCmd = new SqlCommand(cmdText,myCon);
int nresult = -1; myCon.Open(); nresult = myCmd.ExecuteNonQuery;
myCon.Close();
return nresult; }引用文件的代码为:
protected void enterbtn_Click(object sender, EventArgs e)
{
User user = new User();
user.UpdateUserPartPim(userid, realname.Text.Trim(), sex.SelectedValue, grade.Text.Trim(), sclass.Text.Trim(), province.Text.Trim(), county.Text.Trim(), address.Text.Trim(), sectionnum.Text.Trim(), phone.Text.Trim(), email.Text.Trim());
Response.Redirect("userpartpim.aspx");
}
==========>
userid.ToString()在数据库中根据不存在这样的字段值