Before in this thread:
http://www.vbforums.com/showthread.php?t=610716
Where i removed Optomisic Concurrency. Now that I've updated from MSAccess to SqlServer, i need it again.

But it would still be unideal to use the ConflictOption: CompareAllSearchableValues
But i also found and looked into the Conflict Option: CompareRowVersion
I've looked into MSDN to see how to use it, but it doesn't provide any explanation on how to use it.

Also, another problem is with my CommandBuilder.
I can use Builder.GetUpdateCommand.CommandText to get my command text, which will return something like:
UPDATE [table1] SET [Field1] = @p1, [Field2]=@p2, [Field3]=@p3 WHERE (([ID] = @p4))

I was wondering if i could change that string? For my example i may wish to update it to something like:
UPDATE [table1] SET [Field1] = @p1, [Field2]=@p2, [Field3]=@p3 [Timestamp] = @Now_Timestamp WHERE (([ID] = @p4) AND [Timestamp] = @Original_Timestamp)

Thanks.