Click here to Skip to main content
11,705,451 members (60,045 online)
Click here to Skip to main content

Gridview inside Gridview in ASP.NET C#

, 9 Jun 2011 CPOL 123.3K 7.2K 42
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.

You may also be interested in...

Comments and Discussions

 
GeneralMy vote of 2 Pin
sudeep123456725-Jul-11 1:03
membersudeep123456725-Jul-11 1:03 
GeneralMy vote of 5 Pin
Prasanta_Prince19-Jun-11 9:20
memberPrasanta_Prince19-Jun-11 9:20 
GeneralMy vote of 5 Pin
Monjurul Habib9-Jun-11 10:26
memberMonjurul Habib9-Jun-11 10:26 
nice work
GeneralMy vote of 5 Pin
waqas3161-Jun-11 23:43
memberwaqas3161-Jun-11 23:43 
GeneralMy vote of 5 Pin
canozurdo24-May-11 3:11
membercanozurdo24-May-11 3:11 
GeneralRe: My vote of 5 Pin
Prasanta_Prince25-May-11 21:52
memberPrasanta_Prince25-May-11 21:52 
GeneralI do not want to restore a new database to run nested gridview.. Pin
Ravi Sant24-May-11 3:00
memberRavi Sant24-May-11 3:00 
GeneralRe: I do not want to restore a new database to run nested gridview.. Pin
Prasanta_Prince24-May-11 7:20
memberPrasanta_Prince24-May-11 7:20 
GeneralRe: I do not want to restore a new database to run nested gridview.. Pin
AspDotNetDev24-May-11 11:32
mvpAspDotNetDev24-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 | Terms of Use | Mobile
Web01 | 2.8.150819.1 | Last Updated 9 Jun 2011
Article Copyright 2011 by Prasanta_Prince
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid