I believe that the functionality you are looking for is called GetChanges()

According to the docs.. this is what GetChanges does

Gets a copy of the DataSet containing all changes made to it since it was
last loaded, or since AcceptChanges was called.

You can also determine the status of each row in a datatable using the
DataRowState property.

There are other state checking devices built into the ado.net dataset.




>John,
>
>To put it in VFP terms, .NET is missing OLDVAL()/CURVAL().
>
>What an oversight! As is the missing GETFLDSTATE() and GETNEXTMODIFIED(), or even the old SCATTER/GATHER -mess... Hard(er) to know what the others OR your user himself has changed during a screen session.
>
>Pertti
>
>
>>Mike,
>>
>>What I usually do is timestamp the record. If the timestamp doesn't match when I update the record, then I return an error message saying the record has already been updated
>>
>>Yeah that would work, but there's still a "human" intervention that would not be necessary with decent change tracking. The whole system seems designed for 2 tiers until MS delivers the promised changes.