Read XML File Into DataTable In ASP.NET C# VB

In this example i'm explaining how to Read XML File Data Into DataTable In Asp.Net Using C# And VB.NET

I have created a XML File which contains FirstName, LastName and Location sub elements which is shown below.

Element name Employee must be passed while creating object of DataTable. 







XML Data

---

01<!--?xml version="1.0" standalone="yes"?-->

02<details>

03  <employee>

04    <firstname>Amit</firstname>

05    <lastname>Jain</lastname>

06    <location>Mumbai</location>

07  </employee>

08  <employee>

09    <firstname>User</firstname>

10    <lastname>1</lastname>

11    <location>Delhi</location>

12  </employee>

13  <employee>

14    <firstname>User</firstname>

15    <lastname>2</lastname>

16    <location>Bangalore</location>

17  </employee>

18</details>

Write below mentioned code in Click event of Read Button.

C# CODE

---

01protected void btnReadXmlFile_Click(object sender, EventArgs e)

02    {

03        string filePath = Server.MapPath("~/Employees.xml");

04        //Employee Must match with the element name in

05        //your file

06        DataTable dt = new DataTable("Employee");

07 

08        //Add Columns in datatable

09        //Column names must match XML File nodes

10        dt.Columns.Add("firstname", typeof(System.String));

11        dt.Columns.Add("lastname", typeof(System.String));

12        dt.Columns.Add("location", typeof(System.String));

13 

14        //Read XML File And Display Data in GridView

15        dt.ReadXml(filePath);

16        GridView1.DataSource = dt;

17        GridView1.DataBind();

18    }

VB.NET CODE

---

01Protected Sub btnReadXmlFile_Click(sender As Object, e As EventArgs)

02 Dim filePath As String = Server.MapPath("~/Employees.xml")

03 'Employee Must match with the element name in

04 'your file

05 Dim dt As New DataTable("Employee")

06 

07 'Add Columns in datatable

08 'Column names must match XML File nodes

09 dt.Columns.Add("firstname", GetType(System.String))

10 dt.Columns.Add("lastname", GetType(System.String))

11 dt.Columns.Add("location", GetType(System.String))

12 

13 'Read XML File And Display Data in GridView

14 dt.ReadXml(filePath)

15 GridView1.DataSource = dt

16 GridView1.DataBind()

17End Sub