Detect changes prior updating the field

[uuthanh]

Hi Experts,

How do I detect any changes to the field since last time I view it on the web form before updating it?

Here's my problem:

I'm developing a trouble ticket system in multi-user enviroment. user 1 is going to update a "notes" field, in that meantime, user 2 already modified it. So without seeing new update from user 2, user 1 accidentally owerwrites it.

Is there a way to inform user 1 when he click on "Save Notes" button that the field was modified since last time he views it??

Please help!

 

[Dimandja]

That are several methods used to solve this problem. here is one:

When reading data for update, store the "last updated time" value. Check this value against the database before updating.

Design, design.

__________________________________________
Try forum1391 for lively discussions

 

[uuthanh]

Thank you for responding, Dimandja!

I'm using sqlDataAdapter1, sqlConnection1, DsNotes1. Is there any built-in function or property from dataset or dataadapter to detect this? My problem is very common in the web (disconnected) environment, has Microsoft developed anything from their .NET to do this?

Thanks again.

 

[Dimandja]

MS SQL has this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_1mi1.asp

__________________________________________
Try forum1391 for lively discussions