When ADO.Net was being built, they built it with XML in mind. It’s very easy to extract XML data from a DataSet in ADO.Net.


Once you’ve got your DataSet built with any number of tables, relationships, data, etc, all you’ve got to do is call the following method:

C#
ds.WriteXML(@"c:\YourXMLFileName.xml");
VB
ds.WriteXML("c:\YourXMLFileName.xml")