Thanks for your response Jeff.

>If you look closer, you will probably see that only the columns that change are updated, but the WHOLE table is used to verify there have been no changes to the record since you retrieved it.

I did look closer and every column is being updated even if the column was not modified. Why should it work that way?

>You can use the ConcurrencySelectStatement or the dataset's UpdateCommand to change the fields used for concurrency testing. It's an ADO.net issue.

Where can I find the ConcurrencySelectStatement that you mentioned?

Sam