Click here to Skip to main content
15,891,033 members
Search within:


How to prevent or handle multiple user updatation in same row.?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
ASP.NET
SQL-Server
How to prevent or handle multiple user updatation in same row.?
Posted
Add a Solution

2 solutions

see this Introduction to Locking in SQL Server and also
Best practices for inserting/updating large amount of data in SQL 2008

You can also use Transaction A Beginner's Tutorial for Understanding Transactions and TransactionScope in ADO.NET
 
Share this answer
 
Posted
Updated 9-Dec-13 5:58am
v2
Comments
Ganesh Raja 9-Dec-13 10:03am    
Thanks for the post...:)
Basically the row level lock will happen when we are trying to update and delete the data.But if more then 1 user access to update or delete the data in same time,then how can we handle the situation?[it will queued and will wait for certain time and process the request in db side but the first data updation taking long time then surly next queue data will throw the dead lock error right?]
Is this need to handle in db side or application side?
Vishal Pand3y 9-Dec-13 11:34am    
When you insert/update/delete a row in Sql, sql will lock the table/row/page to guarantee that you will be able to do what you want. This lock will be released when you are done inserting/updating/deleting the row.
This is called concurrency issue. look at the article to understand.

http://blog.sqlauthority.com/2012/11/15/sql-server-concurrency-basics-guest-post-by-vinod-kumar/[^]
 
Share this answer
 
Posted
Comments
Ganesh Raja 9-Dec-13 10:04am    
Thanks for the post...:)
Basically the row level lock will happen when we are trying to update and delete the data.But if more then 1 user access to update or delete the data in same time,then how can we handle the situation?[it will queued and will wait for certain time and process the request in db side but the first data updation taking long time then surly next queue data will throw the dead lock error right?]
Is this need to handle in db side or application side?
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to generate a same UID for a row which will load multiple time and update with different data
How to prevent multiple logins for same user in windows application C#?
Prevent multiple login
How do I update multiple rows in SQL server
Prevent same user login from multiple times at the same time
Handle multiple user click on the same button
How to handle multiple user concurrency in booking system
How to update multiple rows in one column inside datagridview
Prevent ASP.NET users from multiple logins at the same time
Multiple User Sql Update at same time

Advertise
Privacy
Cookies
Terms of Use
Last Updated 9 Dec 2013
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900