刚接触ADO.NET，列表修改的问题，请教~

[herenkui4650]

private void btnUpdate_Click(object sender, System.EventArgs e)
        {
          
            bool changed = false;
            for (int i = 0; i < tableScore.Rows.Count; ++i)
            {
                SqlConnection con = new SqlConnection(Data.connectionString);
                if (tableScore.Rows[i].RowState == DataRowState.Modified)
                {
                    string sqlStr = @"update {0} set {1}='{2}' where {3}='{4}' and {5}='{6}'";
                    sqlStr = string.Format(sqlStr, Data.t_sc, Data.c_sc_score, dgvScore.Rows[i].Cells[Data.c_sc_score].Value.ToString(),
                        Data.c_student_snum, dgvScore.Rows[i].Cells[Data.c_student_snum].Value.ToString(),
                        Data.c_course_cnum, dgvScore.Rows[i].Cells[Data.c_course_cnum].Value.ToString()
                        );
                    con.Open();
                    SqlCommand cmd = new SqlCommand(sqlStr, con);
                    cmd.ExecuteNonQuery();
                    con.Close();
                    changed = true;
                }
            }

            if (changed)
            {
                MessageBox.Show("更新成功!");
            }
            else
            {
                MessageBox.Show("更新失败!");

            }
           
        }

完整代码链接：http://pan.baidu.com/s/1eSxmPcI 密码：jbst
刚接触ADO.NET请问最后一个修改成绩的功能为什么总是更新失败，应该怎么修改

[exception92]

会调试比编程重要。http://www.cnblogs.com/alexis/archive/2010/11/06/1870519.html

[ManBOyyy]

1.tableScore.Rows.Count没有数据。 2.tableScore.Rows[i].RowState 不等于 DataRowState.Modified 。好好学习一下基础

[娃都会打酱油了]

你直接贴异常信息不就得了，谁没事去下的代码运行一下