Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

Open and read an XML file to Dataset

Anonymous User 1789 15 Jun 2013

Hi MindStickians,

How to Open and read an XML file to Dataset?

Thanks in advance.

Anonymous User

Other

I am a content writter !

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

advertising