代码:
string strName,strMemo,strUpdate,strSql;
strName = ((TextBox)e.Item.Cells[0].Controls[0]).Text.Trim();
strMemo = ((TextBox)e.Item.Cells[1].Controls[0]).Text.Trim();
int intID = Convert.ToInt32(this.grdList.DataKey[e.Item.ItemIndex].ToString());
strSql = "update test set name='"+strName+"',memo='"+strMemo+"' where id='"+intID+"'";提示UPDATE语句语法错误_!!
update语句不能那么写吗?
string strName,strMemo,strUpdate,strSql;
strName = ((TextBox)e.Item.Cells[0].Controls[0]).Text.Trim();
strMemo = ((TextBox)e.Item.Cells[1].Controls[0]).Text.Trim();
int intID = Convert.ToInt32(this.grdList.DataKey[e.Item.ItemIndex].ToString());
strSql = "update test set name='"+strName+"',memo='"+strMemo+"' where id='"+intID+"'";提示UPDATE语句语法错误_!!
update语句不能那么写吗?
一句话用了两个SQL的保留字 name id
应该这样strSql = "update test set [name]='"+strName+"',memo='"+strMemo+"' where [id]='"+intID+"'";