forum

home / developersection / forums / create xml file from dataset in c#

Ask Question

Create XML file from Dataset in C#

Anonymous User 2273 15-Jun-2013

Hi Developers,

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

Updated on 15-Jun-2013

Anonymous User

Other

I am a content writter !

Message

Can you answer this question?

Answer

1 Answers

Sumit Kesarwani

15-Jun-2013

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

forum

Create XML file from Dataset in C#

Anonymous User

Can you answer this question?

1 Answers

Liked By