Salam
I have a Problem, I have Created an Application in Asp.net, there is a module in which Administrator can Edit INformation regarding users, I am concerned that if one user is editing an information,another user logs in and opens the same user information,modifies it and at the same time both users click "save",What would Happen?,same situation with new user creation.Does IIS maintains "Semaphore" conditions itself or should I check it pragrammily?, I shall be very glad if someone helps me in that situation

Heartily Thanks

I think you need to do it programmatically..For new user check for the data already exists or not in the database and for edit if one user edits the page set some flag as true.When he saves the data set the flag as false.Allow other user to edit the information only when the flag is false.
   Are you giving administator rights to many people?

No Actually, Administrator could be more than one people,and u know that web applications are distributed.I thougth IIS would maintain this situation itself.
Well Thanks a lot for Help

Sorry for the question.Administator can be more than one people.

If you wish to prevent the race condition of two people modifying the same user at the same time, you must do that programatically- SQL SERVER and IIS won't do that for you.

Of course, you could lock the row as soon as someone starts editing, this way no one else could go in and edit that row. Ask about how to do that in the SQL SErver forum.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee