CREATE XML FILE FROM DATASET IN C#

Total Post:119

Points:835
C# 
C#
 1348  View(s)
Ratings:
Rate this:
Hi Developers,

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

  1. Post:100

    Points:700
    Re: Create XML file from Dataset in C#

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

      Modified On Mar-30-2018 04:38:59 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!