我现在在做一个学生成绩的数据库,想用update语句将dataset中的内容保存入数据库,下面是我的部分设置参数代码:
sqldataadapter1.UpdateCommand = new SqlCommand("UPDATE 学生选课 SET 成绩=? WHERE 学号=? AND 课程号=?",thisconnection);
SqlParameter gradeparam = new SqlParameter("成绩",SqlDbType.SmallInt);
gradeparam.SourceColumn = "成绩";
gradeparam.SourceVersion = DataRowVersion.Current;
SqlParameter stdidparam = new SqlParameter("学号",SqlDbType.Char,20);
stdidparam.SourceColumn = "学号";
stdidparam.SourceVersion = DataRowVersion.Original;
SqlParameter eleidparam = new SqlParameter("课程号", SqlDbType.Char,10);
eleidparam.SourceColumn = "课程号";
eleidparam.SourceVersion = DataRowVersion.Original;
sqldataadapter1.UpdateCommand.Parameters.Add(gradeparam);
sqldataadapter1.UpdateCommand.Parameters.Add(stdidparam);
sqldataadapter1.UpdateCommand.Parameters.Add(eleidparam);
运行时候,我改了成绩的数据,却显示 '?' 附近有语法错误,请问如何解决?
sqldataadapter1.UpdateCommand = new SqlCommand("UPDATE 学生选课 SET 成绩=? WHERE 学号=? AND 课程号=?",thisconnection);
SqlParameter gradeparam = new SqlParameter("成绩",SqlDbType.SmallInt);
gradeparam.SourceColumn = "成绩";
gradeparam.SourceVersion = DataRowVersion.Current;
SqlParameter stdidparam = new SqlParameter("学号",SqlDbType.Char,20);
stdidparam.SourceColumn = "学号";
stdidparam.SourceVersion = DataRowVersion.Original;
SqlParameter eleidparam = new SqlParameter("课程号", SqlDbType.Char,10);
eleidparam.SourceColumn = "课程号";
eleidparam.SourceVersion = DataRowVersion.Original;
sqldataadapter1.UpdateCommand.Parameters.Add(gradeparam);
sqldataadapter1.UpdateCommand.Parameters.Add(stdidparam);
sqldataadapter1.UpdateCommand.Parameters.Add(eleidparam);
运行时候,我改了成绩的数据,却显示 '?' 附近有语法错误,请问如何解决?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货