Hi,

I have an ADO.NET application. When an update occurs, instead of finding the row to update by querying only on the columns that comprise the primary key, I need to query on all columns of the table that may have been changed since I did the read. In the case where a row has changed, the update will fail. I need a way of informing the user that the data has changed since the time that He/she read it, and asking her if He/she’d like to overwrite the changes, cancel her update, or examine the differences between her data and the new data in the database. What can I do to get this job done? Please give me some tips.
 

3 MONTHS FREE & FREE SETUP on ASP.NET 3.5/2.0 Web Hosting! Windows 2008 & 2003 Servers Available, MS SQL 2008/2005, .NET 3.5 SP1, Entity Framework, LINQ, Silverlight 2.0, 30 Day Money Back Guarantee – Click Here!

in the table you can add a new colum where you save the timestamp in it..

get the timestamp"time last time it is change".. put it somewhere ..mm.. maybe hiddenfield..

user push submit.. hiddenfield check timestamp.. is the same then do  update/insert

if not  respons.write("error"); respson.end();