Hi all,
I am having a problem with using SqlCeDataAdapter to update the database. I am working with the dataset and the data adapter to do my Select,Insert,Update,Delete . The Dataset holds the results of the select commmand and I store the adapter in a Hashtable .When the user does an insert ,I retrieve this adapter from the Hashtable , set the Insert command and update the adapter.This works fine and I am able to insert multiple rows . The problem appears when I try to update a newly inserted row , one that was not displayed in the search results when the application loaded this form. Then I get a Concurrency violation , No records updated exception . The same goes for deleted rows . Can some one tell me what is happening ?.Also how do I go about solving this problem?.
Thanks,
Raja
Andrzej WegierskiPosted Dec 8, 2005, 2:02 AM
Search on net. I found some other possibilities for concurrency violation:
- floating numbers in key. For instance 1.666667 saved in decimal(3,2)
- autogenerated primary key (from answer to Your post ...)