From DataSet to XmlDocument

Author: Rob Lang

URL: http://www.maison-de-stuff.net/rob/

// From DataSet to XmlDocument

/*
  Ever had to take a DataSet from the database and turn it into an
  Xml Document in .NET? The process is a little messy because there
  is no direct conversion method. This is because Xml is streamed from
  the DataSet but the XmlDocument needs a string to load from.

  Here's my solution:
*/

// 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);