各位师兄，帮帮忙！

[nimeila]

我想；批量更新 成绩 ，但运行时提示 update语句语法错误 数据库中成绩字段为int型，学号为字符型，课程代码为int型
protected void Button1_Click(object sender, EventArgs e)
{
int rowCount = GridView1.Rows.Count;

OleDbCommand comm;
for (int i = 0; i < rowCount; i++)
{
connection = new OleDbConnection(ConnStr);
GridViewRow row = GridView1.Rows[i];
string StuID = row.Cells[1].Text;
string ClassID = row.Cells[2].Text;
TextBox tb = (TextBox)row.Cells[3].FindControl("cj");
string score = tb.Text.ToString();
comm = new OleDbCommand("update score2 set 成绩=" + score + " where 学号='" + StuID + "' and 课程代码="+ ClassID +"", connection);
connection.Open();
comm.ExecuteNonQuery();
connection.Close();
}

[暖枫无敌]

comm = new OleDbCommand("update score2 set 成绩=" + int.Parse(score) + " where 学号='" + StuID + "' and 课程代码="+ int.Parse(ClassID), connection);

[huijunliang]

[Quote=引用 1 楼 的回复:]
comm = new OleDbCommand("update score2 set 成绩=" + int.Parse(score) + " where 学号='" + StuID + "' and 课程代码="+ int.Parse(ClassID), connection);
[/Quote]

+1

[yy5408408]

TextBox tb = (TextBox)row.Cells[3].FindControl("cj");
string score = tb.Text.ToString();
改成
int score=convert.toInt32(gvID.row[i].findControl("cj") as TextBox);

[yy5408408]

rows[i] ......少了个s

[yy5408408]

int score=convert.toInt32((gvID.rows[i].findControl("cj") as TextBox).Text);

[nimeila]

谢谢各位！解决了！

[nimeila]

各位师兄，都不行啊！

[骑着蜗牛去爬山]

单步调试一下，看看取的值有没有错。

[EnForGrass]

首先调试score StuID ClassID 是否取到了值？
另外 sql语句改成如下试试
comm = new OleDbCommand("update score2 set [成绩]=" + Convert.ToInt32(score) + " where [学号]='" + StuID + "' and [课程代码]="+ Convert.ToInt32(ClassID), connection);