vidyade 0 Newbie Poster

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;
        
    }
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.