I have a system I wrote in VB6 / SQL 2000 which I have to re-write / re-design in .Net (my first .net app).

This app gets data from the db via stored procs, and updates the db via stored procs. MANY users use this system. All data displayed in the front end is disconnected. The changes made in the front end are sent to the database and updated, but not before checks are made to ensure other users have not updated the data in the mean time.

Now from what I can tell, I can pretty much do this by just using the DataReader.

If I want to use the DataAdapter and DataSet how can I ensure I only update the db with my DataSet if no other users have updated the same records in the db with their DataSet?

Hope I explained that ok.