Post
Ask Question

Bind GridView from XML in ASP.NET

We need to have an XML file. Below is our XML. We will create a web application. Add this XML file in the solution.

  1. <?xml version="1.0" encoding="utf-8" ?>  
  2. <STUDENTS>  
  3.     <STUDENT>  
  4.         <StudentID>1</StudentID>  
  5.         <Name>John Smith</Name>  
  6.         <Marks>200</Marks>  
  7.     </STUDENT>  
  8.     <STUDENT>  
  9.         <StudentID>2</StudentID>  
  10.         <Name>Mark Johnson</Name>  
  11.         <Marks>300</Marks>  
  12.     </STUDENT>  
  13.     <STUDENT>  
  14.         <StudentID>3</StudentID>  
  15.         <Name>Nitin Tyagi</Name>  
  16.         <Marks>400</Marks>  
  17.     </STUDENT>  
  18. </STUDENTS>  
Add a webpage. Write the following code in the .aspx file.
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Index.aspx.cs" Inherits="BindGridviewFromXML.Index" %>
  2.   
  3. <!DOCTYPE html>  
  4.   
  5. <html xmlns="http://www.w3.org/1999/xhtml">  
  6.   
  7. <head runat="server">  
  8.     <title></title>  
  9. </head>  
  10.   
  11. <body>  
  12.     <form id="form1" runat="server">  
  13.         <div>  
  14.             <asp:GridView ID="Grddata" runat="server" AutoGenerateColumns="false">  
  15.                 <Columns>  
  16.                     <asp:BoundFieldDataField="StudentId" HeaderText="StudentId" />  
  17.                     <asp:BoundFieldDataField="Name" HeaderText="Name" />  
  18.                     <asp:BoundFieldDataField="Marks" HeaderText="Marks" />  
  19.   
  20.                 </Columns>  
  21.             </asp:GridView>  
  22.         </div>  
  23.     </form>  
  24. </body>  
  25.   
  26. </html>  
Now we need to write some code to bind the gridview. Have a look at the code below.
  1. using System;  
  2. usingSystem.Data;  
  3. usingSystem.Web.UI;  
  4. namespaceBindGridviewFromXML  
  5. {  
  6.     public partial class Index: System.Web.UI.Page  
  7.     {  
  8.         protected void Page_Load(object sender, EventArgs e)  
  9.         {  
  10.             if (!Page.IsPostBack)  
  11.             {  
  12.                 BindGridview();  
  13.             }  
  14.         }  
  15.         protected void BindGridview()  
  16.         {  
  17.             using(DataSet ds = new DataSet())  
  18.             {  
  19.                 ds.ReadXml(Server.MapPath("~/Students.xml"));  
  20.                 Grddata.DataSource = ds;  
  21.                 Grddata.DataBind();  
  22.             }  
  23.         }  
  24.     }  
  25. }  
Let us run the application now and check the output.



Gridview is displaying the records that were present in the XML file.

 
Next Recommended Reading Get ASP.NET Web API To Return JSON Instead Of XML