When multiple users attempt to modify data at the same time
Ex user 1 is updating record at same time user2 deleted
record sucessfully.now user1 has press update button . how
to handle concurrency

Answer Posted / umar topia

Have one column with in Database table with datatype as
TimeStamp and while selecting the row we will read the
TimeStamp value, which we can compare at the time of updation,

if both values are same then we can update that row
otherwise we can resist the user from updating saying that
someone has updated the row, you can't update it.

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which database is the ado.net sql connection object designed for?

818


What is ado.net tutorial?

689


What is ado net stands for?

707


What is a datagridview?

733


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

745


Which object holds only data and does not interact with data source?

723


What is difference between ado.net and asp net?

751


What is disconnected data?

777


What are the connected and disconnected modes in ado.net?

698


Why do we use sqldataadapter?

712


What are the uses of Stored Procedure?

775


How many major types of connection objects in ADO.NET?

806


What are all the commands used with Data Adapter?

728


What is ambient transaction?

688


What are the advantages of oledb compared with other classes?

2561