Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 10585 Views
- Digital Group, I also Faced
- E-Mail Answers
Answer Posted / kiranmadiraju
You can use one primary key and one timestamp field to sort
out the problem of concurrency.
The steps are like this
1.Fetch the record from database and store the primary key
value and timestamp in the session.
2.Update the same record with new values other fields using
the same session values for primary key and timestamp fields.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is ole in vb?
What is sqldatareader?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What is the use of ADO.NET and XML web services?
What are the ado.net components?
What are the benefits of ADO.NET?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is ado and dao?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What is defaultview in datatable?
What is shadow copy?
How can we check that some changes have been made to dataset since it was loaded?
What is the use of connection object in ado.net?
What are the steps to connect to a database?
What is openquery?
