Concurrency Problem

[GetOn GetGoing]

Hi To All How do u will handle concurrency in dotnet? For Example: If two users attempting to modify the same records. How dotnet will take care abt this? I mean how one user can check wheather the change to that particular record has been made Praveen

[Mazdak]

It handld based on CultureInfo.NumberFormat of OS on user computer. IF you want everybody set the same format you should set this property in your apilcation. Mazy "Improvisation is the touchstone of wit." - Molière

[John Kuhn]

I think that Mazy missed the point of your question... Concurrency sounds a lot like Currency ;). Anyway, in order to handle concurrency (two users trying to update the same record at the same time) you could do a couple of things: * Use SqlTransactions and to execute your commands, stored procs, etc. in the context of a transaction. Handle exceptions that are generated. * Rely on the "built-in" concurrency of ADO.NET, which will through a DBConcurrencyException if there is more than one user trying to update the same record(s) at the same time. Seach for "concurrency, ADO.NET concurrency control" in the Visual Studio.NET documentation.