执行修改时关键字 'and' 附近有语法错误.

执行修改时关键字 'and' 附近有语法错误.
private string GET_RJZZQXX = "select * from rxzzqxx";
private string CHECK_RJZZQXX = "select rjzzqID,owner,softname,catagory,sydw,softnumber,djsj,otherowner from rxzzqxx where rjzzqID=@rjzzqID and owner=@owner and softname=@softname and catagory=@catagory and sydw=@sydw and softnumber=@softnumber and djsj=@djsj and otherowner=@otherowner";
private const string ADD_RJZZQXX = "insert into rxzzqxx(rjzzqID,owner,softname,catagory,sydw,softnumber,djsj,otherowner) values(@rjzzqID,@owner,@softname,@catagory,@sydw,@softnumber,@djsj,@otherowner)";
private const string DEL_RJZZQXX = "delete from rxzzqxx where rjzzqID=@rjzzqID";
private const string MOD_RJZZQXX = "update rxzzqxx set owner=@owner and softname=@softname and catagory=@catagory and sydw=@sydw and softnumber=@softnumber and djsj=@djsj and otherowner=@otherowner where rjzzqID=@rjzzqID";
private const string QUERY_RJZZQXX = "select * from rxzzqxx where ";
private const string QUER_LIST = "select * from rxzzqxx";
private const string QUER_LIST_TEXTBOX = "select * from rxzzqxx where rjzzqID=";
值不能为 null.
参数名:control if (Modify.modifyuser(rjzzqID,owner,softname,catagory,sydw,softnumber,djsj,otherowner))
{
ScriptManager.RegisterStartupScript(UpdatePanel2,this.GetType(),"updateScript","alert('修改成功!')",true);
SELECT();
}值不能为 null.
参数名:control
亨达利 1年前 已收到1个回答 举报

大悟终空新 幼苗

共回答了17个问题采纳率:94.1% 举报

update rxzzqxx set owner=@owner and softname=@softname and catagory=@catagory and sydw=@sydw and softnumber=@softnumber and djsj=@djsj and otherowner=@otherowner where rjzzqID=@rjzzqID
把set后的and改成逗号,
update rxzzqxx set owner=@owner ,softname=@softname ,catagory=@catagory ,sydw=@sydw ,softnumber=@softnumber ,djsj=@djsj ,otherowner=@otherowner where rjzzqID=@rjzzqID;
补充:
在update或者insert 的时候,有字段不允许为null,但是你传了null过去.

1年前 追问

10

亨达利 举报

您看一下后面的问题 大神求指导 我刚开始学这个
可能相似的问题
Copyright © 2024 YULUCN.COM - 雨露学习互助 - 17 q. 2.217 s. - webmaster@yulucn.com