Subject: Concurrency Violation performing Database updates
Posted By: LaFeverMF Post Date: 2/13/2004 7:33:47 PM
We are inserting a new record in the datasource, setting new identity.  We capture data fields in the dataset with that identity as key.  Push back to original record, but adds two records, rather than updating first record.  We get a concurrency violation if we accept changes after the insert.  We are brand new at VB.Net.

Reply By: DesertPalm Reply Date: 2/15/2004 12:51:55 PM
Hi!
it is very unclear what you are trying to do.

from my little experience in concurrency errors,
try this solution to get rid of the error:
add and remove the records from the dataset,
perform update from the data adapter,

and my point is - do AcceptChanges() method at the end only!
hope it helped in any way..


Go to topic 9820

Return to index page 948
Return to index page 947
Return to index page 946
Return to index page 945
Return to index page 944
Return to index page 943
Return to index page 942
Return to index page 941
Return to index page 940
Return to index page 939