I load up a datatable - bind it to a binding source and a binding navigator - and lots of textboxes on the screen bound to that as well.

When I get a concurrency violation - another user has already changed my vendor, let's say - what is the best method to go about refreshing the datatable with current data from the DB?

I hate to clear the whole datatable just because one row in the DB changed...