Locking Database Edit
-
Im writing an asp.net application that 5 persons will be using. How do i go about locking data edit when its been editing by another person
-
Im writing an asp.net application that 5 persons will be using. How do i go about locking data edit when its been editing by another person
recording currently user,then locked it -- when someone login,recording his info in database,then otherone login,access this info table,if someone in it ,then locked database for this one
-
Im writing an asp.net application that 5 persons will be using. How do i go about locking data edit when its been editing by another person
This question really belongs in the ASP.NET forum. But, since, in an ASP.NET app, there is no guarantee that the person will actually edit and submit the changes before the session times out. Does it sounds like locking records is not a good idea? You'll have to write code to handle the timeout of the session and, if you get no response from the user, unlock the records in the database. If you really want to do this, you'll have to implement some kind of "checkout" scheme in your own custom session manager.
Dave Kreskowiak Microsoft MVP - Visual Basic
-
This question really belongs in the ASP.NET forum. But, since, in an ASP.NET app, there is no guarantee that the person will actually edit and submit the changes before the session times out. Does it sounds like locking records is not a good idea? You'll have to write code to handle the timeout of the session and, if you get no response from the user, unlock the records in the database. If you really want to do this, you'll have to implement some kind of "checkout" scheme in your own custom session manager.
Dave Kreskowiak Microsoft MVP - Visual Basic
Would not Transactional-updates also be a factor here? Locking the entries for the purpose of updating their content without allowing anybody else to simultaneously modify the same information. Correct me if I'm wrong, but I figured this was more of a TSQL question :)
Jonathan Sampson www.SampsonResume.com