Articles → ADO.NET → Convert Datatable To XML In C#

Convert Datatable To XML In C#






Code


using System.Data; 
using System.IO;
 
namespace ConsoleApplication1 {
    class Program {
        static void Main(string[] args) {
            DataSet ds = new DataSet();
            DataTable dt1 = new DataTable();
            dt1.Columns.Add("Name", typeof(string));
            DataRow row1 = dt1.NewRow();
            row1["Name"] = "Test name";
            dt1.Rows.Add(row1);
 
            DataTable dt2 = new DataTable();
            dt2.Columns.Add("Address", typeof(string));
            DataRow row2 = dt2.NewRow();
            row2["Address"] = "Test address";
            dt2.Rows.Add(row2);
 
            ds.Tables.Add(dt1);
            ds.Tables.Add(dt2);
 
            string dsXml = ds.GetXml();
            string xmlFile = @"c:\temp\test.xml";
 
            using(StreamWriter fs = new StreamWriter(xmlFile)) // XML File Path
            {
                ds.WriteXml(fs);
            }
        }
    }
}



Output


Picture showing the output of converting datatable to xml in C#
Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Wednesday, July 18, 2018

Query/Feedback


Your Email Id
 
Subject
 
Query/FeedbackCharacters remaining 250