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”.
In The Hand Ltd 