Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



When multiple users attempt to modify data at the same time Ex user 1 is updating record at same ti..

Answer / 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

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same ti..

Answer / 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

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same ti..

Answer / shweta

we can have to use exclusive locks on the table thats why
we can't change data at a time..

Is This Answer Correct ?    3 Yes 1 No

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same ti..

Answer / gt

provide the transactionlevels

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

What is Pooling? what is data pooling? what is sql pooling?

3 Answers   TCS,


What is difference between datatable and dataset?

0 Answers  


What we do with the object of ado.net dataset after using it?Can we dispose it or can we set it nothing?Is it must or not?

4 Answers   SVI,


What are two types of transaction supported by ado.net?

0 Answers  


What are the several execute methods of ado.net?

0 Answers  


What are the classes in System.Data.Common Namespace?

0 Answers  


How can you add or remove rows from the datatable object of dataset?

0 Answers  


Explain executenonquery?

0 Answers  


What does ado stand for in ado.net?

0 Answers  


What is the difference between sqlcommand and sqldataadapter?

0 Answers  


How do you connect to sql server database without using sqlclient?

0 Answers  


What are the three Objects of ADO.

10 Answers  


Categories