forum

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

Ask Question

Create XML file from Dataset in C#

Anonymous User 2177 15-Jun-2013
Hi Developers,

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

c# c# 
Updated on 08-Jul-2013
Anonymous User

Other

I am a content writter !

Follow
Can you answer this question?
Answer

1 Answers

Vijay Shukla

Vijay Shukla

08-Jul-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);
        }
    }
}
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy