C# code to bind XML data to Grid view


In this article i am going to explain about the code used to bind the xml data to grid view. 


In this article to explain the process i have a grid view named mygrid and a XML File named details.xml.

First the xml file is read from the specified path. Then the xml is read into the dataset. Then the dataset is assigned as datasource to the grid view. To use the dataset we should add the below namespace.

using System.Data;

Below is the html ASPX code.

<%@ PageLanguage=”C#”AutoEventWireup=”true”CodeFile=”Default.aspx.cs”Inherits=”_Default”%>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head runat=”server”>
    <form id=”form1″ runat=”server”>
        <asp:GridView ID=”myGird” runat=”server”AutoGenerateColumns=”False”CellPadding=”4″
                <asp:BoundField HeaderText=”Id”DataField=”Id”/>
                <asp:BoundField HeaderText=”Name”DataField=”Name”/>
                <asp:BoundField HeaderText=”Position”DataField=”Position”ItemStyle-HorizontalAlign=”Right” />

Add below code in page load event in code behind file
protected void Page_Load(object sender, EventArgse)
    DataSet ds;
    string filePath = Server.MapPath(“Details.xml”);
    ds = new DataSet();
    myGird.DataSource = ds.Tables[0].DefaultView;

Thus the above code binds xml data to grid view.

Do you like this article. Then comment here or share with your friends. Or like our Facebook page. 

Subscribe For Latest Updates

Signup for our newsletter and get notified when we publish new articles for free!