arch_and

arch_and

  • NA
  • 2
  • 0

Concurrency Violations in SqlCeDataAdapter

Nov 28 2005 6:52 PM

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


Answers (1)