.NET中数据更新的问题
做了个更新,但是更新不了数据库,断点设置能执行,又找不出错在哪里。郁闷啊!!!
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 ");
}
------解决方案--------------------楼主仔细一点,这样的问题,仔细一点就不会出现了