Posted by Alec on Tue, 07 Apr 2009, in ASP.NET C#
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);