i have a problem with datatables.

Lets say i have a table containg two fields that are both primary keys,

I then connect to the table using the usual ado net connection process.
connection->sqlcommand->sqladapter->sqlcommandbuilder(using the sqlcommand)->datatable

Then afterwards, i binded it to the Datagridview. I inserted two rows on the datagridview:

Field1            Field2
Value1          Value1Desc
Value2          Value2Desc

I saved it using the sqladapter.update(datatable) command and worked okay.

Next I Deleted the second row:
Field1            Field2
Value1          Value1Desc
Value2          Value2Desc (delete)

Next I Inserted a new row with the same values as the previously deleted row.

Field1            Field2
Value1          Value1Desc
Value2          Value2Desc (New Row Inserted)

then i called the sqladapter.update(datatable)  command. what happens next? errrorrrr!!!!!

if anyone knows how to go about the incoming error please tell me how to fix it.

And also can i change the way the update,insert,delete logic is performed on the command builder? lets say i want delete first then update and finally insert?


____________________________
Error 404 ...File not found...!!!!

Hi,
The error is probably because your cached recordset is inconsistent with the database. Run the update command after the delete to synchronize the recordsets, then run the insert for the new record.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.

quote:

---

GeoffS wrote:
Hi,
The error is probably because your cached recordset is inconsistent with the database. Run the update command after the delete to synchronize the recordsets, then run the insert for the new record.

---