第一次修改数据后,点保存成功,后台SQL可查到保存成功的数据。
但接着在表格再修改数据,点保存就提示此错误 。
private void btnMoRenAmount_Click(object sender, EventArgs e)
{
gridView1.CloseEditor();
gridView1.UpdateCurrentRow();
PublicInfo.updateData(dsVoicDtl, dtVoicDtl, "SELECT * FROM InvoiceDtl where 1=2")
}
public static bool updateData(DataSet ds, DataTable dt, string strsql)
{
bool flag = false;
// DataAdoCon.adoCon.Open();
SqlCommand sqlcmd = new SqlCommand(strsql, ConnectionPool.getPool().getConnection());
using (SqlDataAdapter da = new SqlDataAdapter(sqlcmd))
{
SqlCommandBuilder builder = new SqlCommandBuilder(da);
try
{
//builder.ConflictOption = ConflictOption.OverwriteChanges;
//builder.SetAllValues = false;
// builder.DataAdapter = da;
// ds.AcceptChanges(); //针对违反并发性: UpdateCommand 影响了预期 1 条记录中的 0 条
da.UpdateCommand = builder.GetUpdateCommand();
int ii = da.Update(ds, dt.TableName);
flag = true;
}
catch (SqlException ea)
{
flag = false;
throw new Exception(ea.Message);
}
}
// DataAdoCon.adoCon.Close();
return flag;
}