Concerning using dataadapter to update data in the database, I've learned that we can fetch the data from the database and put it into a dataset object. The connection is disconnected and we can make any update to the dataset. When we want to pass whatever changes we make back to the database, we can use dataadapter.update method. My question is how does dataadapter recognise which data has been updated, inserted or deleted by the user? Does it compare the dataset with the actual data in the database?
Thanks for the explanation.