How do i properly code to deal with concurrencies? {I have more questions....}

Question

Hi I'm guessing that i should use a datasets handle concurrencies with tables. assume that when the user requests for a record and the BLL sends a dataset (or DataTable called Customers). Another user also request the same record thus returns another dataset with the same name Customers. So therefore theer are two dataset of teh same name. If this is the case if the first user makes changes to a field that should notify the user 2 about the changes... How do i implement his in my point of view i shoud link the two datasets (of the same type) so each one will sync eachother.... Is this the way to deal with concurrecies......? TY IN advance

Kirtan Patel · Answer

Use Transactions instread of Simply SqlCommand Object in the Code to Control Concurrency :)

Roei Bar · Answer

here you go my friend this is a way todo the update by TimeStamp http://www.codeproject.com/KB/aspnet/concurrentupdates.aspx or using .NET 4 http://blogs.mscommunity.net/blogs/borissevo/archive/2008/02/27/concurrent-programming-in-c-parallel-do-method.aspx

petre ricardo · Answer

Thanks for all your answers! However i'm looking for links that deals with the concurrency using code not by designer. Typically i only use the designer to Drag and drop items to the form and to generate events on controls. all the other i do by code...so i'm not that much used to the creating connections using the designer... therefore please give links or ways to solve my concurrency issues with code : ) TY

Roei Bar · Answer

here is a gr8 sample for Optimistic Concurrency http://msdn.microsoft.com/en-us/library/bb404102.aspx

Roei Bar · Answer

well my friend the thought is nice but its incurrect each user has his very own instance of the DataSet meaning that each one will have his own changes without the other one knowing on them until the change has been done and another request has been asked which will contain the changes