这是加载,程序开始的时候加载dtAllQty表(在外的地方加载的)然后和dtqty这个表合并一下,
dtAllQty字段比dtqty多,去掉一些多余的字段,dtqty表和下面那句sql字段是一样的但是保存的时候总是提示
违反并发性: UpdateCommand 影响了预期 1 条记录中的 0 条。不知道为什么?
string sql = @"select top 1 monthy,processid,shiftid,empid,workqty,monthreward,qualityrate,jumprate,JumpReward,profitreward,addreward,buckqty,buckreward,realreward,persons,avgreward,judgtime from monthdonereward where 1=2";
dtQty = SqlHelper.GetDataTable(sql);
dtQty.Merge(dtAllQty, true, MissingSchemaAction.Ignore);
dgview.DataSource = dtQty.DefaultView;
string sql = @"select monthy,processid,shiftid,empid,workqty,monthreward,qualityrate,jumprate,JumpReward,profitreward,addreward,buckqty,buckreward,realreward,persons,avgreward,judgtime from monthdonereward";
try
{
SqlConnection con = new SqlConnection(Config.ConnectionString);
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter ada = new SqlDataAdapter(cmd);
SqlCommandBuilder build = new SqlCommandBuilder(ada);
ada.Update(dtQty);
dtAllQty字段比dtqty多,去掉一些多余的字段,dtqty表和下面那句sql字段是一样的但是保存的时候总是提示
违反并发性: UpdateCommand 影响了预期 1 条记录中的 0 条。不知道为什么?
string sql = @"select top 1 monthy,processid,shiftid,empid,workqty,monthreward,qualityrate,jumprate,JumpReward,profitreward,addreward,buckqty,buckreward,realreward,persons,avgreward,judgtime from monthdonereward where 1=2";
dtQty = SqlHelper.GetDataTable(sql);
dtQty.Merge(dtAllQty, true, MissingSchemaAction.Ignore);
dgview.DataSource = dtQty.DefaultView;
string sql = @"select monthy,processid,shiftid,empid,workqty,monthreward,qualityrate,jumprate,JumpReward,profitreward,addreward,buckqty,buckreward,realreward,persons,avgreward,judgtime from monthdonereward";
try
{
SqlConnection con = new SqlConnection(Config.ConnectionString);
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter ada = new SqlDataAdapter(cmd);
SqlCommandBuilder build = new SqlCommandBuilder(ada);
ada.Update(dtQty);
解决方案 »
- 再问查询开启两个线程,结束后dataGridView滚动条失效
- 向[superdullwolf]提问!
- DataGridView绑定datatable,改变datatable如何更行DataGridView
- 一个特殊的SQL语句
- FastZip异常问题
- 如何在page页里的普通超链节激活一个c#里的函数执行呢
- vc软件包不可用或是未注册
- c#中listview中的操作问题,急急
- soap扩展客户端设置(解决问题马上结帖)
- 如何在DataGrid的下面显示“合计”一行数据?
- 违反并发性: UpdateCommand 影响了预期 1 条记录中的 0 条
- .net2008中WPF,WCF是什么东东,分别做什么用的
1 有重复记录(包括主键不正确)
2 有字段值在更新前已被修改