Monday, August 6, 2012

Bind XML Grid View asp.net

Student XML
    <?xml version="1.0" encoding="utf-8" ?>

    <Student>

      <detail>

        <Name>Jone</Name>

        <Age>12</Age>

        <Grade>A</Grade>

      </detail>

      <detail>

        <Name>Juhe</Name>

        <Age>13</Age>

        <Grade>C</Grade>

      </detail>

    </Student>


HTML Grid View

    <html xmlns="http://www.w3.org/1999/xhtml">

    <head runat="server">

    <title>Bind XML file to Grid View</title>

    </head>

    <body>

    <form id="form1" runat="server">

    <div>

    <asp:GridView ID="GvStudentsList" runat="server" AutoGenerateColumns="false" Width="30%" HeaderStyle-ForeColor="White" HeaderStyle-Height="50" >

    <Columns>

    <asp:TemplateField HeaderStyle-BackColor="ActiveCaption" HeaderText="Name" ItemStyle-HorizontalAlign="Center"

    ItemStyle-Height="40">

    <ItemTemplate>

    <asp:Label ID="Label1" runat="server" Text='<%# Eval("Name") %>'></asp:Label>

    </ItemTemplate>

    </asp:TemplateField>

    <asp:TemplateField HeaderStyle-BackColor="ActiveCaption" HeaderText="Age" ItemStyle-HorizontalAlign="Center">

    <ItemTemplate>

    <asp:Label ID="Label1" runat="server" Text='<%# Eval("Age")  %>'></asp:Label>

    </ItemTemplate>

    </asp:TemplateField>

    <asp:TemplateField HeaderStyle-BackColor="ActiveCaption" HeaderText="Grade" ItemStyle-HorizontalAlign="Center">

    <ItemTemplate>

    <asp:Label ID="Label1" runat="server" Text='<%# Eval("Grade")  %>'></asp:Label>

    </ItemTemplate>

    </asp:TemplateField>

    </Columns>

    </asp:GridView>

    </div>

    </form>

    </body>

    </html>

C# Code 
      protected void Page_Load(object sender, EventArgs e)

        {

            // create a new data set

            DataSet stdataset = new DataSet();

            // get the xml file

            string filePath = Server.MapPath("Students.xml");

            //Read the contents of the XML file into the DataSet

            stdataset.ReadXml(filePath);

            // bind dataset to gridview

            GvStudentsList.DataSource = stdataset.Tables[0].DefaultView;

            GvStudentsList.DataBind();

        } 


Result 


No comments:

Post a Comment