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

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" <(E-Mail Removed)>
>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: <(E-Mail Removed)>
>Newsgroups: microsoft.public.dotnet.languages.vb
>NNTP-Posting-Host: 61.247.249.25
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.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
any
>locking technics.
>
>
>Need Advice
>
>Babz
>
>
>
>