违反并发性????

[youmin0]

我想交换两个表中的内容
就是把A表中的某条记录复制到B表中

::DataRow ^newrow=this->MyDataTable_Pass->NewRow();
newrow->default["title"]=this->MyRows_UnPass->default[i]->default["title"];
......
newrow->default["class"]=this->MyRows_UnPass->default[i]->default["class"];
this->MyRows_Pass->Add(newrow);
this->MyAdapter_Pass->Update(this->MyDataTable_Pass);
MyDataTable_Pass->AcceptChanges();

接着我想让B表中的刚转过来的那条记录再复制到A表中(同上面复制一样过程)
出现了这个错误:违反并发性: DeleteCommand 影响了预期 1 条记录中的 0 条；
那么解决呢

[youmin0]

UPUP

[youmin0]

UP

[youmin0]

再UP
分不够继续加

[bluealarm]

我也出现了类似问题,不知道怎么回事?

[真相重于对错]

再贴全点代码
::DataRow ^newrow=this->MyDataTable_Pass->NewRow();
newrow->default["title"]=this->MyRows_UnPass->default[i]->default["title"];
......
newrow->default["class"]=this->MyRows_UnPass->default[i]->default["class"];MyRow_UnPass是什么？？？

this->MyRows_Pass->Add(newrow); //Myrows_pass是什么？
this->MyAdapter_Pass->Update(this->MyDataTable_Pass);
MyDataTable_Pass->AcceptChanges();

[zamfox]

你可以先用sql查询分析器看看是不是数据库的问题

[youmin0]

对了
每个表都是有个自增主键

[youmin0]

我做得是这样的一个审核系统
未审核和审核的后缀分别是_UnPass和_pass

楼上的那个MyRows_UnPass和Myrows_pass类型是DataRowCollection
是读取了数据的DataRowCollection
就是这样了

[jenycheng]

N 足鼎立

[rigofree]

顶

[莆田zencart建站]

where 赋值问题

[莆田zencart建站]

string strConnection = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=d:\lswj;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
OdbcConnection connection = new OdbcConnection(strConnection);
string selectCommand = "SELECT * FROM cgdb2007";
OdbcDataAdapter daInfo = new OdbcDataAdapter(selectCommand, connection);
daInfo.UpdateCommand = new OdbcCommand("update cgdb2007 set hm=? where id =127773 ");
//daInfo.UpdateCommand.Parameters.Add("@id", OdbcType.VarChar).Value ="id";
daInfo.UpdateCommand.Parameters.Add("@hm", OdbcType.VarChar).Value ="hm";
OdbcCommandBuilder scb = new OdbcCommandBuilder(daInfo);
daInfo.InsertCommand = scb.GetInsertCommand();
connection.Open();
DataSet dsnew = new DataSet();
daInfo.Fill(dsnew, "cgdb2007");
DataColumn[] keys = new DataColumn[] { dsnew.Tables[0].Columns["id"] }; //设置表的主键信息
dsnew.Tables[0].PrimaryKey = keys;
daInfo.Update(dsnew, "cgdb2007");
connection.Close();
[align=left]

[/align]

[莆田zencart建站]

string strConnection = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=d:\lswj;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
OdbcConnection connection = new OdbcConnection(strConnection);
string selectCommand = "SELECT * FROM cgdb2007";
OdbcDataAdapter daInfo = new OdbcDataAdapter(selectCommand, connection);
daInfo.UpdateCommand = new OdbcCommand("update cgdb2007 set hm=? where id =127773 ");
//daInfo.UpdateCommand.Parameters.Add("@id", OdbcType.VarChar).Value ="id";
daInfo.UpdateCommand.Parameters.Add("@hm", OdbcType.VarChar).Value ="hm";
OdbcCommandBuilder scb = new OdbcCommandBuilder(daInfo);
daInfo.InsertCommand = scb.GetInsertCommand();
connection.Open();
DataSet dsnew = new DataSet();
daInfo.Fill(dsnew, "cgdb2007");
DataColumn[] keys = new DataColumn[] { dsnew.Tables[0].Columns["id"] }; //设置表的主键信息
dsnew.Tables[0].PrimaryKey = keys;
daInfo.Update(dsnew, "cgdb2007");
connection.Close();



//把更新条件值直接赋值看能否更新 可以的话说明是 where赋值问题