Question

c#数据库编程 提示update语法错误 没错啊 请大侠赐教

string strSql = "update ParaRegister set isChecked=" + bool.Parse(dgvPara.Rows[i].Cells[0].Value.ToString()) + ", Description='" + dgvPara.Rows[i].Cells[1].Value.ToString() + "',";
strSql += "DataFormat='" + dgvPara.Rows[i].Cells[4].Value.ToString() + "',";
strSql += "DataRegionMark='" + dgvPara.Rows[i].Cells[3].Value.ToString() + "',";
strSql += "DataValue='" + dgvPara.Rows[i].Cells[5].Value.ToString() + "',";
strSql += "where RegisterAdd='" + dgvPara.Rows[i].Cells[2].Value.ToString().Trim() + "' ";
strSql += "and DeviceID='" + comboBox58.SelectedValue + "'";
db.ExecuteNoQuerySql(strSql);

Answer 1

Sql 没有bool值
将isChecked=True 改为 isChecked=1
bool.Parse(dgvPara.Rows[i].Cells[0].Value.ToString()) 改为 int.Parse(dgvPara.Rows[i].Cells[0].Value.ToString())

Answer 2

试试第5行改为 strSql += "DataValue='" + dgvPara.Rows[i].Cells[5].Value.ToString() + "'";

Answer 3

你调试到这里，选择html显示就可以看到他们拼接的结果

追问

update ParaRegister set isChecked=True, Description='TV变比',DataFormat='INT32',DataRegionMark='1~3000',DataValue='5',where RegisterAdd='41000' and DeviceID='3'

结果是这样的 没错啊 那怎么debug到db.ExecuteNoQuerySql(strSql);这句 就报错说update语法错误呢

追答

你用它在SQL里运行下就可以看到哪里错了...