Hi jayachitra ,
Have a look at my sample,
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSourceSelectArguments arg = new DataSourceSelectArguments();
DataView dv = this.SqlDataSource1.Select(arg) as DataView;
this.GridView1.DataSource = dv;
GridView1.DataBind();
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
GridView inner = e.Row.FindControl("GridView2") as GridView;
DataSourceSelectArguments arg = new DataSourceSelectArguments();
DataView dv = this.SqlDataSource1.Select(arg) as DataView;
inner.DataSource = dv; inner.DataBind();
}
}
protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView self = sender as GridView;
self.PageIndex = e.NewPageIndex;
DataSourceSelectArguments arg = new DataSourceSelectArguments();
DataView dv = this.SqlDataSource1.Select(arg) as DataView;
self.DataSource = dv; self.DataBind();
} <form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="countryid"
Width="320px" OnRowDataBound="GridView1_RowDataBound">
<Columns>
<asp:BoundField DataField="countryid" HeaderText="countryid" ReadOnly="True" SortExpression="countryid" />
<asp:BoundField DataField="countryname" HeaderText="countryname" SortExpression="countryname" />
<asp:TemplateField>
<ItemTemplate>
<asp:GridView ID="GridView2" runat="server" AllowPaging="True" PageSize="2" OnPageIndexChanging="GridView2_PageIndexChanging">
</asp:GridView>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
SelectCommand="SELECT * FROM [country]"></asp:SqlDataSource>
</form>