Question

C# '=' 附近有语法错误。

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
this.bind();

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int ID = Convert.ToInt32(GridView1 .DataKeys [e.RowIndex].Value.ToString ());
string userName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString();
string userPwd = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString();
string sqlStr = "updatetb_user set username='"+userName +"userpwd="+userPwd+"' where ID="+ID;
string myStr = ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection myCon = new SqlConnection(myStr);
myCon.Open();
SqlCommand mySdr = new SqlCommand(sqlStr ,myCon );
mySdr.ExecuteNonQuery();
mySdr.Dispose();
myCon.Close();
GridView1.EditIndex = -1;
this.bind();
}

就是在更新的时候有问题。

Answer 1

string sqlStr = "updatetb_user set username='"+userName +"userpwd="+userPwd+"' where ID="+ID;

假如 username 是 abc
userpwd 是 123
ID 是 100
最后的 SQL 是

updatetb_user set username='abcuserpwd=123' where ID=100

理论上的SQL应该是
update b_user set username='abc', userpwd='123' where ID=100

是不是缺少一个逗号的原因?

Answer 2

漏了几个符号，更正如下
string sqlStr = "updatetb_user set username='"+userName +"',userpwd='"+userPwd+"' where ID="+ID;

Answer 3

sql语句有误，仔细检查SQL语句。

Answer 4

string sqlStr = "updatetb_user set username="+userName +",userpwd="+userPwd+" where ID="+ID;