Hi! Steve,
I am not an expert. I respect Cathi and Bonnie, both are much more knowledgable then me.
I think what you want is to remove those changes from the dataset which are temperory to ADO.NET and not stored in DB. Have you used RejectChanges function of dataset.
dsFoo.RejectChanges may help you.
Even bonnie had helped me on the same king of query. Bonnie's answer was much better. I don't remember the code at present. I can give you the code, if you want, as that code is at my home PC.
Regards
Ritesh.
If you are courageous, listen to your heart. If you are coward, listen to your head.