Bind GridView from XML in ASP.NET

Nitin
8y
1.7k
0
2

Blog

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

<?xml version="1.0" encoding="utf-8" ?>
<STUDENTS>
<STUDENT>
<StudentID>1</StudentID>
<Name>John Smith</Name>
<Marks>200</Marks>
</STUDENT>
<STUDENT>
<StudentID>2</StudentID>
<Name>Mark Johnson</Name>
<Marks>300</Marks>
</STUDENT>
<STUDENT>
<StudentID>3</StudentID>
<Name>Nitin Tyagi</Name>
<Marks>400</Marks>
</STUDENT>
</STUDENTS>

Add a webpage. Write the following code in the .aspx file.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Index.aspx.cs" Inherits="BindGridviewFromXML.Index" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="Grddata" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundFieldDataField="StudentId" HeaderText="StudentId" />
<asp:BoundFieldDataField="Name" HeaderText="Name" />
<asp:BoundFieldDataField="Marks" HeaderText="Marks" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>

Now we need to write some code to bind the gridview. Have a look at the code below.

using System;
usingSystem.Data;
usingSystem.Web.UI;
namespaceBindGridviewFromXML
{
public partial class Index: System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindGridview();
}
}
protected void BindGridview()
{
using(DataSet ds = new DataSet())
{
ds.ReadXml(Server.MapPath("~/Students.xml"));
Grddata.DataSource = ds;
Grddata.DataBind();
}
}
}
}

Let us run the application now and check the output.

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

Up Next

ASP.NET

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

Ebook Download

View all

C# Corner Ebook

Hands on ASP.NET GridView

Read by 12k people

Download Now!

Learn

View all

Learn Image