ADO.net Locking system

[vishal]

Hi all,
If i am using Dataset in my ASP.net APplication & i am
expecting many people visting & updating data on my site.
wht will happen if many people update dataset at the same
time...how locking system works in ado.net ?

 

[msnews.microsoft.com]

If you use the native methods, the second update will fire a concurrency
exception, which you can handle. The DataSet keeps the original rows, for
comparison, as well as the edited rows. If the original rows are changed,
..NET will take over and make the update fail on those that retrieve before
another user's update and attempt to update their data after.

Dino Esposito's MS Press book has a great chapter on handling concurrency.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************