Handling concurrency with table adapter manager

[John]

Hi

I am updating my data on a winform db app as so;

Me.TableAdapterManager.UpdateAll(Me.MyDataSet)

How can I handle data concurrency error in this situation specially when
table adapter manger may be handling more than one data adapter/data table?

Thanks

Regards

 

[William Vaughn \(MVP\)]

Again, I discuss several concurrency strategies in my book but I generally
try to design the application and structure the data to prevent
collisions--not try to figure out what to do after they occur. When an
Update fails due to a collision (and it's not the cause of your own
application), something (or someone) has to decide how to untangle the mess.
Do you force through the last change? (Washington DC approach) Do you simply
accept that a change has beat you to the row? (the "laid-back" approach) or
let the user (eventually) decide.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________