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...hConcurrencyIn
ADONET.asp

Walkthrough: Handling a Concurrency Exception
http://msdn.microsoft.com/library/en...ngconcurrencye
xception.asp

hope that helps
Steve
Visual Basic Team

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

From: "Babz" <no******@nodomain.com>
Subject: Concurrent Updation problem
Date: Wed, 8 Oct 2003 18:33:04 +0530
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <eT**************@TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.dotnet.languages.vb
NNTP-Posting-Host: 61.247.249.25
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:145392
X-Tomcat-NG: microsoft.public.dotnet.languages.vb

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 anylocking technics.
Need Advice

Babz