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 |