Advertise with us

Create XML file from Dataset in C#

Hi Developers,

How can I create a XML file from Dataset in C#?

Last updated:7/8/2013 2:00:59 AM

1 Answers

Vijay Shukla
Vijay Shukla

Hi Goti,

You can use this code:

using System;
using System.Data;
using System.Windows.Forms;
using System.Xml;
 
 
namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        DataTable dt;
 
        public Form1()
        {
            InitializeComponent();
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            dt = new DataTable();
            dt.Columns.Add(new DataColumn("Product_ID", Type.GetType("System.Int32")));
            dt.Columns.Add(new DataColumn("Product_Name", Type.GetType("System.String")));
            dt.Columns.Add(new DataColumn("product_Price", Type.GetType("System.Int32")));
            fillRows(1, "product1", 1111);
            fillRows(2, "product2", 2222);
            fillRows(3, "product3", 3333);
            fillRows(4, "product4", 4444);
            ds.Tables.Add(dt);
            ds.Tables[0].TableName = "product";
            ds.WriteXml("Product.xml");
            MessageBox.Show("Done");
        }
 
        private void fillRows(int pID, string pName, int pPrice)
        {
            DataRow dr;
            dr = dt.NewRow();
            dr["Product_ID"] = pID;
            dr["Product_Name"] = pName;
            dr["product_Price"] = pPrice;
            dt.Rows.Add(dr);
        }
    }
}

Last updated:7/8/2013 2:00:59 AM

Answer