From DataSet to XmlDocument

brainwipe (Rob Lang) — Mon, 19 Mar 2007 15:58:12 GMT

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

DZone Snippets: database code

From DataSet to XmlDocument