DBConcurrencyException

Question

User2015131882 posted

good day.

I need to update table contents via dataadapter.

one of fields set automatically on update/insert by database.

and my sqldataadapter.update(myDataTable) get DBConcurrencyException.

Update command made by  SqlCommandBuilder.

How can I avoid this exception?

Answer 1

User2015131882 posted

sqldataadapter.ContinueOnErrors

Answer 2

User-1635004338 posted

Hi comphead,

Have a look at these two links with some solutions of DBConcurrencyException:

http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic37891.aspx

http://scruffylookingcatherder.com/archive/2006/11/21/4-solutions-to-dbconcurrencyexception-in-datasets.aspx

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

Thanks,