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 |