CODEWITHSUNDEEP
c#.netxmlxml-serializationdatatable
Vara Prasad.M
Vara Prasad.M

Reputation: 1550

How can I convert a DataTable to an XML file in C#?

I want to convert a DataTable to an XML file in C#. How can I do this?

Upvotes: 18

Views: 99941

Answers (3)

kiran
kiran

Reputation: 1072

Another way to get this done is by adding the data table to dataset and calling the GetXml() on the dataset.In addition to this dataset is equipped with the WriteXml() and ReadXml() for writing/reading the XML directly to/from a file path or stream.

DataSet ds = new DataSet();
ds.Tables.Add(dt1); // Table 1
ds.Tables.Add(dt2); // Table 2...
...
string dsXml= ds.GetXml();
...
using (StreamWriter fs = new StreamWriter(xmlFile)) // XML File Path
{
      ds.WriteXml(fs);
}

Upvotes: 8

Soner Gönül
Soner Gönül

Reputation: 98740

You can use DataTable.WriteXml Method.

Here is an example;

How can i convert my datatable into XML using C# 2.0?

string result;
using (StringWriter sw = new StringWriter()) {
dataTable.WriteXml(sw);
result = sw.ToString();
}

If you don't actually need a string but read-only, processable XML, it's a better idea to use MemoryStream and XPathDocument:

XPathDocument result;
using (MemoryStream ms = new MemoryStream()) {
dataTable.WriteXml(ms);
ms.Position = 0;
result = new XPathDocument(ms);
}

Upvotes: 33

Ryan Castillo
Ryan Castillo

Reputation: 1125

You can use the writeXML method to save it as XML (Source).

You can also use serialization/desirialization as described in the fifth post of this forum.

Upvotes: 9

Related Questions