Dataset Changes

[James Doughty]

Hello all,

I have a dataset that I do inserts/updates/deletes. Then I call the
SQLDataAdapter.Update to perform the inserts/updates/deletes. The issue is
if I call the SQLDataAdapter.Update it accepts the changes and GetChanges
returns no changes, if I call GetChanges before I call the
SQLDataAdapter.Update I get the changes but there is no guarentee that the
record (due to the identity column) will be the same a the one in the
database the since other users may have added records.

Any suggestions? ideas?

Thanks,
James