 |  |  |  |  |  |  |  |
Preventing multiple admin doing concurrent updates on the database
Please support our ASP.NET advertiser: Intel Parallel Studio Home
 |
Hello ,
My application has an admin section which stores its password in web.config file. There can be case when simultaneosly 2 administrator logs in admin section and try to update the same database. I want to prevent this from happening. Can anyone suggest how to implement this. Update functionality runs via threading.
Regards,
Pradeep
My application has an admin section which stores its password in web.config file. There can be case when simultaneosly 2 administrator logs in admin section and try to update the same database. I want to prevent this from happening. Can anyone suggest how to implement this. Update functionality runs via threading.
Regards,
Pradeep
•
•
Join Date: Aug 2008
Posts: 1,162
Reputation: 
Solved Threads: 137
agree with jbennet
you can choose to create your own method of locking, or go by sql physical locking
not sure what db or version you are using, but the sql concepts are row lock or table lock
if you want to implement this yourself, you can add a locked column to the row and set to 1 or 0 depending upon its current state
you can choose to create your own method of locking, or go by sql physical locking
not sure what db or version you are using, but the sql concepts are row lock or table lock
if you want to implement this yourself, you can add a locked column to the row and set to 1 or 0 depending upon its current state
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
|
Other Threads in the ASP.NET Forum
- Previous Thread: SQL format exception
- Next Thread: unable to open .aspx file on my IE7.0
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
.net 2.0 ajax alltypeofvideos appliances application asp asp.net bc30451 beginner box browser button c# cac checkbox class commonfunctions control countryselector dataaccesslayer database datagridview datagridviewcheckbox datalist deployment development dgv dialog dropdownlist dynamic dynamically edit embeddingactivexcontrol expose feedback fileuploader fill findcontrol flash form formatdecimal formview gridview gudi iis image javascript listbox login microsoft mouse mssql news novell numerical opera panelmasterpagebuttoncontrols parent problem radio redirect registration relationaldatabases reportemail save schoolproject search security select sessionvariables silverlight smoobjects software sql sql-server sqlserver2005 ssl suse textbox tracking treeview unauthorized validatedate validation vb.net video videos vista visualstudio vs2008 web webapplications webdevelopemnt webdevelopment webprogramming webservice wizard xsl youareanotmemberofthedebuggerusers
