c# .net Adsense ADO.NET Linq Viruses/security asp.net MVC JQuery Angular-js Node-js SEO Java C++ SQL API Networking vb.net .Net Css JavaScript Generics c#.Net entity framework HTML Website host Website Construction Guide HTTP tutorial W3C tutorial Web Services JSON Psychology Ionic framework Angular ReactJS Python Computer Android
c# .net

how to read xml and then bind it to GridView control in ASP.Net using c# ?

| | ASP-NET

In this article I will explain how to read the data from XML file and bind toGridView control using C# in ASP.Net.
I have as xml file with name as test.xml.



<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<student>
<id> 1 </id>
<name>Rasik</name>
<gender>Male</gender>
<age>27</age>
</student>
<student>
<id>Thivan</id>
<name>male</name>
<gender>25</gender>
<age>Thivan</age>
</student>
</NewDataSet>


Design a gridview with name as GridView1 in BindGrid.aspx


<asp:GridView ID="GridView1" runat="server"></asp:GridView>


Reading the XML file data and binding it to GridView control



protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
BindGrid();
}
}
private void BindGrid()
{
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/test.xml"));
GridView1.DataSource = ds;
GridView1.DataBind();
}

Output:























Id name gender age
1 Rasik Male 27
2 Thivan male 25