Understanding AcceptChanges and DataAdapter.Update

Bill Ryan from KnowDotNet and Devbuzz has posted an article clearly describing the issues around DataSets which arise commonly on the newsgroups and discussion forums.


http://msmvps.com/williamryan/posts/5679.aspx


These include “Why does calling AcceptChanges followed by DataAdaptor.Update do nothing to the database” and “why doesn’t calling Remove on a row doesn’t remove the row from the database”.