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

---

  
    Amit
    Jain
    Mumbai
  
  
    User
    1
    Delhi
  
  
    User
    2
    Bangalore
  

Write below mentioned code in Click event of Read Button.

C# CODE

---

protected void btnReadXmlFile_Click(object sender, EventArgs e)
    {
        string filePath = Server.MapPath("~/Employees.xml");
        //Employee Must match with the element name in 
        //your file
        DataTable dt = new DataTable("Employee");
        
        //Add Columns in datatable
        //Column names must match XML File nodes
        dt.Columns.Add("firstname", typeof(System.String));
        dt.Columns.Add("lastname", typeof(System.String));
        dt.Columns.Add("location", typeof(System.String));
        
        //Read XML File And Display Data in GridView
        dt.ReadXml(filePath);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }

VB.NET CODE

---

Protected Sub btnReadXmlFile_Click(sender As Object, e As EventArgs)
 Dim filePath As String = Server.MapPath("~/Employees.xml")
 'Employee Must match with the element name in 
 'your file
 Dim dt As New DataTable("Employee")

 'Add Columns in datatable
 'Column names must match XML File nodes
 dt.Columns.Add("firstname", GetType(System.String))
 dt.Columns.Add("lastname", GetType(System.String))
 dt.Columns.Add("location", GetType(System.String))

 'Read XML File And Display Data in GridView
 dt.ReadXml(filePath)
 GridView1.DataSource = dt
 GridView1.DataBind()
End Sub

Tweet

If you like this post than join us or share