C# code to bind XML data to Grid view

By
Advertisement
Introduction:


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


Description:


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.

<%@ Page Language="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">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="myGird" runat="server" AutoGenerateColumns="False" CellPadding="4"
            HeaderStyle-BackColor="blue" HeaderStyle-ForeColor="White" HeaderStyle-HorizontalAlign="Center"
            HeaderStyle-Font-Bold="True">
            <Columns>
                <asp:BoundField HeaderText="Id" DataField="Id" />
                <asp:BoundField HeaderText="Name" DataField="Name" />
                <asp:BoundField HeaderText="Position" DataField="Position" ItemStyle-HorizontalAlign="Right" />
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>

Add below code in page load event in code behind file

protected void Page_Load(object sender, EventArgs e)
{
    DataSet ds;
    string filePath = Server.MapPath("Details.xml");
    ds = new DataSet();
    ds.ReadXml(filePath);
    myGird.DataSource = ds.Tables[0].DefaultView;
    myGird.DataBind();
}

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. 










0 comments:

Post a Comment

Online Casino