Concurrency control in VB.NET

[pradipta]

How can i use concurrency control using vb.net.I have used sqlcommand,sqlconnection and sqldatareader(No Dataset) to access data from database in my project.And multiple user can access and modify data ,so how can i use lock and cursor to maintain consistency in database.

[John Kuhn]

Transactions.

[pradipta]

I will be glad to have a VB.NET code snippet to implement Concurency control when data inserted or updated on the database through command/datareader objects of VB.NET.

[John Kuhn]

I apologize for the brevity of my response -- you can achieve concurrency control using transactions in ADO.NET with the SqlTransaction class (see MSDN[^] for more details). However, the following two examples might be more specific to the issue you are attempting to resolve: MSDN Data Concurrency[^] Data Concurrency Exception Handling[^]