c#sqlexception:””,””附近有语法错误

Question

c#实训，检查了好久都没看到，跪求大佬建议建议我

SqlCommand cmd; cmd = conn.CreateCommand(); cmd.CommandText = "UPDATE Student SET studentID=@studentID WHERE Sname=@Sname,sex=@sex,Dname=@Dname,Pname=@Pname,class=@class,instructor=@instructor,dormitory=@dormitory"; cmd.Parameters.AddWithValue("@studentID",AddstudentID.Text); cmd.Parameters.AddWithValue("@Sname",AddSname.Text); cmd.Parameters.AddWithValue("@sex",Addsex.Text); cmd.Parameters.AddWithValue("@Dname",AddDname.Text); cmd.Parameters.AddWithValue("@Pname",AddPname.Text); cmd.Parameters.AddWithValue("@class",Addclass.Text); cmd.Parameters.AddWithValue("@instructor",Addinstructor.Text); cmd.Parameters.AddWithValue("@dormitory",Adddormitory.Text); cmd.ExecuteNonQuery(); MessageBox.Show("修改成功");

Answer 1

sql语句错了。where 多条件用and不是用逗号分开。而且你应该是通过studentID更新其他信息吧，怎么是更新studentID去了。。

cmd.CommandText = "UPDATE Student SET studentID=@studentID WHERE Sname=@Sname,sex=@sex,Dname=@Dname,Pname=@Pname,class=@class,instructor=@instructor,dormitory=@dormitory";

==》

cmd.CommandText = "UPDATE Student SET Sname=@Sname,sex=@sex,Dname=@Dname,Pname=@Pname,class=@class,instructor=@instructor,dormitory=@dormitory WHERE studentID=@studentID";

如果有帮助请点个采纳，谢谢~