A very useful command to convert dataset or datatable to an XML Document:
// This is the final document
XmlDocument Data = new XmlDocument();
// Create a string writer that will write the Xml to a string
StringWriter stringWriter = new StringWriter();
// The Xml Text writer acts as a bridge between the xml stream and the text stream
XmlTextWriter xmlTextWriter = new XmlTextWriter(stringWriter);
// Now take the Dataset and extract the Xml from it, it will write to the string writer
content.WriteXml(xmlTextWriter, XmlWriteMode.IgnoreSchema);
// Write the Xml out to a string
string contentAsXmlString = stringWriter.ToString();
// load the string of Xml into the document
Data.LoadXml(contentAsXmlString);
If you think this post is useful, please recommend me at the bottom of the page. ;)