forum

home / developersection / forums / open and read an xml file to dataset

Open and read an XML file to Dataset

Anonymous User 1756 15-Jun-2013

Hi MindStickians,

How to Open and read an XML file to Dataset?

Thanks in advance.

c#

Updated on 15-Jun-2013

Anonymous User

Other

I am a content writter !

Message

Can you answer this question?

1 Answers

Sumit Kesarwani

15-Jun-2013

Hi Ashish,

The following code will solve your problem:

using System;
using System.Data;
using System.Windows.Forms;
using System.Xml;
 
namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            XmlReader xmlFile;
            xmlFile = XmlReader.Create("Product.xml", new XmlReaderSettings());
            DataSet ds = new DataSet();
            ds.ReadXml(xmlFile);
            int i = 0;
            for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
            {
                MessageBox.Show(ds.Tables[0].Rows[i].ItemArray[2].ToString());
            }
        }
    }
}

MindStick Training