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

by

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

More Related Contents:

  1. Serialize Property as Xml Attribute in Element
  2. .net XML Serialization – Storing Reference instead of Object Copy
  3. How to decode string to XML string in C#
  4. How to write a comment to an XML file when using the XmlSerializer?
  5. Generating XML file using XSD file
  6. XmlSerializer Performance Issue when Specifying XmlRootAttribute
  7. How do you use XMLSerialize for Enum typed properties in c#?
  8. How to read a CSV file into a .NET Datatable
  9. Generate C# class from XML
  10. Proper way to implement IXmlSerializable?
  11. How do you serialize a string as CDATA using XmlSerializer?
  12. How to serialize/deserialize to `Dictionary` from custom XML not using XElement?
  13. Can I make XmlSerializer ignore the namespace on deserialization?
  14. Deserializing into a List without a container element in XML
  15. How to select min and max values of a column in a datatable?
  16. How to deal with XML in C#
  17. How to compare 2 dataTables
  18. How do you find out when you’ve been loaded via XML Serialization?
  19. get line number for XElement here
  20. Entity Framework with XML Files [closed]
  21. Error Deserializing Xml to Object – xmlns=” was not expected
  22. What are the differences between the XmlSerializer and BinaryFormatter
  23. Suppress Null Value Types from Being Emitted by XmlSerializer
  24. XmlTextReader vs. XDocument
  25. DataTable equivalent in Java [duplicate]
  26. Removing nodes from an XmlDocument
  27. Best way to check if a Data Table has a null value in it
  28. Get Cell Value from a DataTable in C#
  29. Returning DataTables in WCF/.NET
  30. Is there a reason why a base class decorated with XmlInclude would still throw a type unknown exception when serialized?

Leave a Comment