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