<form id="form1" runat="server"> <div> <asp:GridView runat="server" ID="Grd" AutoGenerateColumns="false" OnRowDataBound="OnDataBound"> <Columns> <asp:BoundField DataField="agent_cd" HeaderText="Agent Cd" /> <asp:TemplateField HeaderText ="Agent Details"> <ItemTemplate> <asp:GridView ID="ChldGrid" runat="server"> <Columns> <asp:BoundField DataField="agent_name" HeaderText="Agent Cd" /> <asp:BoundField DataField="address1" HeaderText="Address" /> <asp:BoundField DataField="city" HeaderText="City" /> <asp:BoundField DataField="state" HeaderText="State" /> </Columns> </asp:GridView> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> </div> </form>
//Code for binding the GridViewusing System;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class NestedGridView : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { BindData(); } private void BindData() { try { SqlConnection conn = new SqlConnection(""); conn.Open(); DataTable dt = new DataTable(); SqlDataAdapter ADA = new SqlDataAdapter("", conn); ADA.Fill(dt); Grd.DataSource = dt; Grd.DataBind(); } catch (Exception E) { string str = E.Message; } } protected void OnDataBound(object sender , GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { GridView Grd = (GridView)e.Row.FindControl("ChldGrid"); DataTable dt = new DataTable("TEST"); dt.Columns.Add("agent_cd"); dt.Columns.Add("agent_name"); dt.Columns.Add("address1"); dt.Columns.Add("city"); dt.Columns.Add("state"); dt.ReadXml(Server.MapPath("Data.xml")); Grd.DataSource = dt; Grd.DataBind(); } }}
", conn); ADA.Fill(dt); Grd.DataSource = dt; Grd.DataBind(); } catch (Exception E) { string str = E.Message; } } protected void OnDataBound(object sender , GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { GridView Grd = (GridView)e.Row.FindControl("ChldGrid"); DataTable dt = new DataTable("TEST"); dt.Columns.Add("agent_cd"); dt.Columns.Add("agent_name"); dt.Columns.Add("address1"); dt.Columns.Add("city"); dt.Columns.Add("state"); dt.ReadXml(Server.MapPath("Data.xml")); Grd.DataSource = dt; Grd.DataBind(); } }}
<?xml version="1.0" standalone="yes"?><DocumentElement> <TEST> <agent_cd>00000026</agent_cd> <agent_name>TROPIC ICE INCORPORATED</agent_name> <address1>2805 N COMMERCE PKWY</address1> <city>MIRAMAR</city> <state>FL</state> </TEST></DocumentElement>