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