Click here to Skip to main content
Click here to Skip to main content

Gridview inside Gridview in ASP.NET C#

, 9 Jun 2011
Rate this:
Please Sign up or sign in to vote.
Gridview inside Gridview in ASP.NET C# or Nested Gridview and Update, Delete from Gridview

Introduction

There are lots of situations that come up where we have to show a grid inside another grid, like:

nestedGV1.JPG

And in selecting Expand, you will see that:

nestedGV2.JPG

Here emp_address is in the second Gridview.

In our practical programming scenario, there are lots of situations that come up where we have to show a grid inside another grid. But we can get proper help of that because of proper support or sample. My intention is to give a clear, brief and easy idea of how to implement Nested Gridview or Gridview inside another gridview. Lots of people try to implement that but fail to implement properly.

How to Use

  1. Firstly place a gridview in your solution.
  2. Inside Itemtemplate, place your second gridview.
  3. Place a button for Expand inside an itemtemplate.
  4. In gridview rowdatabound, write the code to bind the second gridview.

Background

The basic idea behind this article is to describe the use of Nested Gridview. There are no proper samples of Nested Gridview.
These codes can be applicable to every Visual Studio compiler.

Using the Code

GridView control retrieved from the SQL database table can be used to uniquely identify the record. In my example, I have given the option for Update and Delete too.

In source, you have to work like that:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" 
        onrowcancelingedit="GridView1_RowCancelingEdit" 
        onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" 
        onrowupdating="GridView1_RowUpdating" OnRowCommand="GridView1_RowCommand">
        <Columns>
        <asp:TemplateField HeaderText="Name">
        <ItemTemplate>
         <asp:Label ID="lblID" runat="server" Text='<%#Eval("ID") %>'></asp:Label>
         <%--<asp:Label ID="Label1" runat="server" Text='<%# Container.DataItemIndex%>'>
	</asp:Label>--%>
        </ItemTemplate>
        </asp:TemplateField>
         <asp:TemplateField HeaderText="A">
        <ItemTemplate>
           <asp:Button ID="btnShow" runat="server" Text="Expand" 
	    CommandName="Show" CommandArgument='<%# Container.DataItemIndex%>' />
        </ItemTemplate>
        </asp:TemplateField>
            <asp:TemplateField HeaderText="Name">
            <ItemTemplate>
                <asp:Label ID="lbl" runat="server" Text='<%#Eval("emp_name") %>'>
		</asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txt" runat="server" Text='<%#Eval("emp_name") %>'>
		</asp:TextBox>
            </EditItemTemplate>
            </asp:TemplateField>
            
            <asp:TemplateField>
            <ItemTemplate>              
                
            <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
        AutoGenerateDeleteButton="False" AutoGenerateEditButton="False" >
        <Columns>
         <asp:BoundField DataField="emp_address" HeaderText="emp_address" 
		SortExpression="emp_address">
                            <ItemStyle Width="20%" />
                        </asp:BoundField>
         </Columns>
    
</asp:GridView>

In my example, I have done the whole thing from one table. In my example, the database table looks like this:

DB1.JPG

In code behind, I have done things with RowCommand event.

The sample code is as given below:

 if (e.CommandName == "Show")
        {
            int RowIndex = Convert.ToInt32((e.CommandArgument).ToString());
            Button btn = (Button)GridView1.Rows[RowIndex].FindControl("btnShow");
           // Label lblID = (Label)GridView1.Rows[RowIndex - 1].FindControl("Label1");
           // int row = Convert.ToInt32(lblID.Text);
            if (btn.Text == "Expand")
            {

                //  Label lblID = (Label)gvDiscMaster.Rows[RowIndex].FindControl("lblID");
                GridView gv = 
		(GridView)GridView1.Rows[RowIndex ].FindControl("GridView2");

                long id = long.Parse
		(((Label)GridView1.Rows[RowIndex].FindControl("lblID")).Text);
                DataSet ds1 = new DataSet();
                ds1 = query.selectwithId(id);
                gv.DataSource = ds1;
                gv.DataBind();
                btn.Text = "Collapse";
            }
            else if (btn.Text == "Collapse")
            {
                GridView gv = (GridView)GridView1.Rows[RowIndex].FindControl("GridView2");

                long id = long.Parse(e.CommandArgument.ToString());
                //DataSet ds1 = new DataSet();
                // ds1 = query.selectwithId(id);
                gv.DataSource = null;
                gv.DataBind();
                btn.Text = "Expand";
            }
        }

Points of Interest

The basic idea behind this article is to describe the use of Nested Gridview. There are no proper samples of Nested Gridview.

History

  • 2nd May, 2011 - Submitted article

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Prasanta_Prince
Software Developer India
India India
http://devcorners.com/
Total DotNet/Programming Solution
 
I am Prasanta Banerjee. I am an Asp.Net Developer. My site: http://devcorners.com/
Email: prasanta.it@hotmail.com
If any body wants to prepare for interview http://guru-code.blogspot.com/ is the good site.

Comments and Discussions

 
Questionpaging of the child gridview PinmemberJocelyne El Khoury1-Jul-14 22:31 
GeneralMy vote of 3 PinmemberDebopam Pal19-Nov-13 4:37 
SuggestionNot like real nested grid view PinmemberDebopam Pal19-Nov-13 4:37 
GeneralRe: Not like real nested grid view PinmemberPrasanta_Prince19-Nov-13 5:53 
GeneralRe: Not like real nested grid view PinmemberDebopam Pal19-Nov-13 7:46 
QuestionHow to handle events in the 2nd grid (Inside Grid)?? Pinmemberkanna.kannanbe19-Aug-13 18:48 
GeneralMy vote of 3 PinmemberMember 997456918-Apr-13 0:08 
QuestionMultiple childgrids in parent grid Pinmemberdilfizo2-Apr-12 1:54 
Hello Sir,can it possible to n number of child grid in parent grid..my urgent requirement is that parent grid and child grid but child grid must be more than 3/4 grids with full functionality like treeview grid .plz help me out sir..thanx in advance..
AnswerRe: Multiple childgrids in parent grid PinmemberPrasanta_Prince11-Jun-12 2:05 
QuestionNice PinmemberRavindra_Parcha11-Feb-12 20:45 
GeneralMy vote of 2 Pinmembersudeep123456725-Jul-11 1:03 
GeneralMy vote of 5 PinmemberPrasanta_Prince19-Jun-11 9:20 
GeneralMy vote of 5 PinmemberMonjurul Habib9-Jun-11 10:26 
GeneralMy vote of 5 Pinmemberwaqas3161-Jun-11 23:43 
GeneralMy vote of 5 Pinmembercanozurdo24-May-11 3:11 
GeneralRe: My vote of 5 PinmemberPrasanta_Prince25-May-11 21:52 
GeneralI do not want to restore a new database to run nested gridview.. PinmemberRavi Sant24-May-11 3:00 
GeneralRe: I do not want to restore a new database to run nested gridview.. PinmemberPrasanta_Prince24-May-11 7:20 
GeneralRe: I do not want to restore a new database to run nested gridview.. PinmvpAspDotNetDev24-May-11 11:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140827.1 | Last Updated 9 Jun 2011
Article Copyright 2011 by Prasanta_Prince
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid