Question

异常详细信息: System.Data.SqlClient.SqlException: ';' 附近有语法错误。

行 72:
行 73: cm.Connection = co;
行 74: cm.ExecuteNonQuery();
行 75:
行 76: cm.CommandText = "update surveylist set question_number=question_number+1 where id=@surveyid6";

cm.CommandText = "insert into questionanswer(survey_id;questionid,answer1,answer2,answer3,answer4) values(@survey_id,@questionid,@answer1,@answer2,@answer3,@answer4)";
cm.Parameters.Clear();
cm.Parameters.AddWithValue("@survey_id", Session["surveyid"]);
cm.Parameters.AddWithValue("@questionid", Session["questionid"]);
cm.Parameters.AddWithValue("@answer1", 0);
cm.Parameters.AddWithValue("@answer2", 0);
cm.Parameters.AddWithValue("@answer3", 0);
cm.Parameters.AddWithValue("@answer4", 0);

cm.Connection = co;
cm.ExecuteNonQuery();
急急急！跪求！

Answer 1

cm.CommandText = "insert into questionanswer(survey_id;questionid,answer1,answer2,answer3,answer4) values(@survey_id,@questionid,@answer1,@answer2,@answer3,@answer4)";
(survey_id;後面符号错了 应该是逗号 你弄成了分号

Answer 2

ExecuteNonQuery() 在微软类库里是一个返回int类型的方法

Answer 3

cm.ExecuteNonQuery();??