c# .net

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

how to read xml and then bind it to GridView control in ASP.Net using c# ? , someone asked me to explain?

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

Post your comments / questions