ASP.NET AJAX Discussion and Suggestions

Re: update the record but only one user ... the time space for other user is for wating...

atanu.podder — Thu, 28 Aug 2008 18:58:35 GMT

You should use some column to indentify the last updated date time. Takin your case, applying my approach:

In the database I have one row which user A and user B both are tryin to update.

What I suggest is:

To update a record you need to select the same, while selcting provide the last updated datetime as well, suppose that was 080820081112. So, user A and user B both have selected the same record and has same last updated datetime value i.e. 080820081112. Now, when user A updates the records, obviously the last updated datetime value would be changed, supposse it bacame 080820081116, now when user B tries to update the same, since the value of last updated datetime does not match with the current one in the database, throw a diffferent message.

Thats it!

Thanks,

Atanu

Re: update the record but only one user ... the time space for other user is for wating...

mrmercury — Thu, 28 Aug 2008 12:55:54 GMT

You could use optimistic locking, one way of doing it is using a timestamp in your record, on submit compared against the database, if it’s different then you would tell the user another user has changed the record.

update the record but only one user ... the time space for other user is for wating...

prashantsvl — Thu, 28 Aug 2008 12:32:11 GMT

hello experts..

I am trying to update the record ... the record update sucessfully . but if there are nos users and if user "A"

trying to update the record & simultaniosly update the user "B" trying to update the record then there should be the message to user 'B' " currently

updating the record... u dont have the chance.. "

so how this situation can handle????????

reply as early as possible...

prashantsvl