如题、以下为代码:
for (int i = 0; i <= dataGridView1.Rows.Count; i++)
{
for (int j = 1; j <= dataGridView1.Rows.Count - 1; j++)
{
string Department_sql = "update B3P3C_Parameters set B3P3C_Parameters_Department='" + department[i] + "' where B3P3C_Row= ‘" + j + "’";
m_reader = m_dbclass.ExcuteOneSQL(Department_sql); }
}
for (int i = 0; i <= dataGridView1.Rows.Count; i++)
{
for (int j = 1; j <= dataGridView1.Rows.Count - 1; j++)
{
string Department_sql = "update B3P3C_Parameters set B3P3C_Parameters_Department='" + department[i] + "' where B3P3C_Row= ‘" + j + "’";
m_reader = m_dbclass.ExcuteOneSQL(Department_sql); }
}
m_reader是SqlDataReader吧
update 执行完返回的是一个int表示影响的行数
你m_reader 是SqlDataReader类型不匹配啊int count =m_dbclass.ExcuteOneSQL(Department_sql);
我和楼主的用户ID很像
而 m_dbclass.ExcuteOneSQL(Department_sql)返回 int 类型,
将m_reader改为 int 类型......
直接执行
m_dbclass.ExecuteNonQuery();不行么?