Concurrent Updation problem

[Babz]

Hi,
How I can prevent concurrent updation of a records in .net.
I am using Dataset which is disconnected from the data source. In this
situation if
two users opens the same record, modifies the data and updates one after
another,
my data won't be in the correct state. How I can prevent this. Is there any
locking technics.


Need Advice

Babz

 

[Steven Stein [MSFT]]

Babz-

Check out the following information on MSDN:

How Visual Studio .NET Generates SQL Statements for Concurrency Control
http://msdn.microsoft.com/library/en-us/dv_vstechart/html/vbtchConcurrencyIn
ADONET.asp

Walkthrough: Handling a Concurrency Exception
http://msdn.microsoft.com/library/en-us/vbcon/html/vbwlkhandlingconcurrencye
xception.asp



hope that helps


Steve
Visual Basic Team

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------