It is source code of design .aspx page.three sqlconnection take three datasource and three gridview
Main problem is that when i what see gridview it showing two gridview Please Tell how can i created the Parentgridview rowediting event .???
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:JAPITConnectionString %>"
SelectCommand="SELECT * FROM [viewyn]"></asp:SqlDataSource>
<asp:GridView ID="ParentGridView" runat="server"
AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" DataKeyNames="l_no"
onrowediting="ParentGridView_OnRowEditing"
onselectedindexchanged="ParentGridView_SelectedIndexChanged">
<Columns>
<asp:TemplateField HeaderText="Letter Number">
<ItemTemplate>
<asp:Label id="l_no" Runat="Server"
Text='<%# Eval("l_no") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="name Department">
<ItemTemplate>
<asp:Label id="nam_dep" Runat="Server"
Text='<%# Eval("nam_dep") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="number DEO">
<ItemTemplate>
<asp:Label id="no_deo" Runat="Server"
Text='<%# Eval("no_deo") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="number month">
<ItemTemplate>
<asp:Label id="no_mon" Runat="Server"
Text='<%# Eval("no_mon") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Letter y/n">
<ItemTemplate>
<asp:Label id="le_yn" Runat="Server"
Text='<%# Eval("le_yn") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Draft y/n">
<ItemTemplate>
<asp:Label id="dd_yn" Runat="Server"
Text='<%# Eval("dd_yn") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="View">
<ItemTemplate>
<asp:Button ID="ViewChild_Button"
runat="server" Text="+" CommandName="Edit" />
</ItemTemplate>
<EditItemTemplate>
<asp:Button ID="CancelChild_Button"
runat="server" Text="-" CommandName="Cancel" />
<asp:GridView ID="GrandChildGridView" runat="server"
AllowPaging="true" PageSize="4"
DataSourceID="SqlDataSource2">
</asp:GridView>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="View2">
<ItemTemplate>
<asp:Button ID="ViewChild_Button1"
runat="server" Text="+" CommandName="Edit" />
</ItemTemplate>
<EditItemTemplate>
<asp:Button ID="CancelChild_Button1"
runat="server" Text="-" CommandName="Cancel" />
<asp:GridView ID="GrandChildGridView1" runat="server"
AllowPaging="true" PageSize="4"
DataSourceID="SqlDataSource3">
</asp:GridView>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:JAPITConnectionString %>"
SelectCommand="SELECT * FROM [entry_dd] WHERE ([l_no] = @l_no)">
<SelectParameters>
<asp:SessionParameter Name="l_no" SessionField="l_no" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:JAPITConnectionString %>"
SelectCommand="SELECT * FROM [Letter_dept] WHERE ([l_no] = @l_no)">
<SelectParameters>
<asp:SessionParameter Name="l_no" SessionField="l_no" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
Now is rowediting code
protected void ParentGridView_OnRowEditing(object sender,GridViewEditEventArgs e)
{
int parent_index = e.NewEditIndex;
//to set the edit index of the Parent
//grid with that of the current row
ParentGridView.EditIndex = parent_index;
ParentGridView.DataBind();
//find the pubid_lbl containing pub_id in that
//particular row by using findcontrol method
GridViewRow row = ParentGridView.Rows[parent_index];
Label l_nu = (Label)row.FindControl("l_no");
//save pub_id and edit_index in session for childgridview's use
Session["l_no"] = l_nu.Text;
Session["ParentGridViewIndex"] = parent_index;
}