DBConcurrency Exception Occured While Updating Using Dataadapter

by

This is because DataAdapter uses Optimistic Concurrency by default. This means that if you are trying to update a row that no longer exists in the database or changed, the update from the DataAdapter will fail with the exception above.

Possible scenarios:

  • Between you selecting the data into the client and sending the
    update, another user is deleting or updating this row from his application.
  • It can be that you are deleting the data from somewhere else in your application.

For example:

  1. You fill the DataTable that will be used for the update.
  2. Deletes the row with Code = 1101 (for example) directly from the database, i.e. you do not use the DataTable here. This is emulating another user deleting the row with Code = 1101 from another application. Or some other part in your code deleting the row with Code = 1101.
  3. Selects out the row with Code = 1101 from the DataTable, this is just to show that it is still there even though you have deleted it from the database itself.
  4. Edits the Quantity column in the row with Code = 1101 in the DataTable. This has to be done, otherwise the call to Update will ignore this row when updating.
  5. Executes the update, this will throw the exception since you are trying to update a row that (no longer) exists in the database.

If you want to implement Last Writer Wins, Add the following code: 

cb.ConflictOption = ConflictOption.OverwriteChanges;

Also there is one more possible thing : if you have Decimal/numeric as columns in the DB they may cause this error even though the data looks the same. This is due to a decimal rounding error.

An important note:
You should always use parameterized queries by the way. This kind of string concatenations are open for SQL Injection.

More Related Contents:

  1. Entity Framework core – Contains is case sensitive or case insensitive?
  2. Entity Framework Core Many to Many change navigation property names
  3. PostgreSQL and C# Datatypes
  4. ComboBox.ValueMember and DisplayMember
  5. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  6. In C#, what is the difference between public, private, protected, and having no access modifier?
  7. Best Practice for Forcing Garbage Collection in C#
  8. How can I String.Format a TimeSpan object with a custom format in .NET?
  9. Using IoC for Unit Testing
  10. C# variable scoping: ‘x’ cannot be declared in this scope because it would give a different meaning to ‘x’
  11. Entering keys manually with Entity Framework
  12. The cast to value type ‘Int32’ failed because the materialized value is null
  13. HTTP Error 500.30 – ANCM In-Process Start Failure
  14. Dynamically Created Controls losing data after postback
  15. Getting the folder name from a full filename path
  16. Order of serialized fields using JSON.NET
  17. How do I determine the standard deviation (stddev) of a set of values?
  18. What are the downsides to turning off ProxyCreationEnabled for CTP5 of EF code first
  19. OutOfMemoryException while populating MemoryStream: 256MB allocation on 16GB system
  20. Set TabPage Header Color
  21. Calculating Bandwidth
  22. Mixed mode assembly is built against version ‘v1.1.4322’
  23. Should I take ILogger, ILogger, ILoggerFactory or ILoggerProvider for a library?
  24. Entity Framework. Delete all rows in table
  25. Where are the ControllerContext and ViewEngines properties in MVC 6 Controller?
  26. Split String into smaller Strings by length variable
  27. Debugging automatic properties
  28. LINQ: Add RowNumber Column
  29. Authentication Service using WCF
  30. How do I call a .NET assembly from C/C++?

Leave a Comment