.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> DataGrid >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Nested Gridview in Asp.net

Posted By:satyapriyanayak       Posted Date: September 28, 2013    Points: 40    Category: DataGrid    URL: http://www.dotnetspark.com  

In this article we will know how to use a gridview inside another gridview. Here in first gridview there are three columns named as DepartmentId, DepartmentName and details. All data of DepartmentId, DepartmentName will be shown in the first gridview along with a details button. So when we will click the Details button then records related to the corresponding DepartmentName will be shown in the second gridview.
 

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    CellPadding="4" ForeColor="#663300" onrowcommand="GridView1_RowCommand" onrowcancelingedit="GridView1_RowCancelingEdit">
            <AlternatingRowStyle BackColor="#CCCC00" />
            <Columns>
                <asp:TemplateField HeaderText="Department_Id">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DepartmentId") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("DepartmentId") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Department_Name">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("DepartmentName") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("DepartmentName") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText = "Details">
               <ItemTemplate>
          <asp:Button ID ="btn_Show" Text="Details" runat= "server" CommandName= "Details" CommandArgument='<%# Container.DataItemIndex%>' />
          <asp:Button ID ="Cancel" Text="Cancel" runat= "server" CommandName= "Cancel" CommandArgument='<%# Container.DataItemIndex%>' Visible="false" />

                    

                       <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#000000" GridLines="Both">
                 <AlternatingRowStyle BackColor="Yellow" />
                        <Columns>
                          <asp:BoundField DataField="Id" HeaderText= "Id" >
                          <ItemStyle Width = "20%" />
                          </asp:BoundField>
                          <asp:BoundField DataField="Name" HeaderText= "Name" >
                          <ItemStyle Width = "20%" />
                          </asp:BoundField>
                          <asp:BoundField DataField="Address" HeaderText= "Address" >
                          <ItemStyle Width = "20%" />
                          </asp:BoundField>
                          <asp:BoundField DataField="Branch" HeaderText= "Branch" >
                          <ItemStyle Width = "20%" />
                          </asp:BoundField>
                          <asp:BoundField DataField="Phone" HeaderText= "Phone" >
                          <ItemStyle Width = "20%" />
                          </asp:BoundField>
                         </Columns>
                         <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="Red" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                        </asp:GridView>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#CC6600" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
        </asp:GridView>
    </div>
    </form>
</body>
</html>


using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    SqlCommand com;
    SqlDataAdapter sqlda;
    DataSet ds;
    string str;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGrid();
        }
    }
    protected void BindGrid()
    {
        SqlConnection con = new SqlConnection(connStr);
        con.Open();
        str = "select * from Department";
        com = new SqlCommand(str, con);
        sqlda = new SqlDataAdapter(com);
        con.Close();
        ds = new DataSet();
        sqlda.Fill(ds, "Department");
        GridView1.DataSource = ds;
        GridView1.DataMember = "Department";
        GridView1.DataBind();
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
  
        int rowindex = Convert.ToInt32(e.CommandArgument.ToString());

        GridView g2 = (GridView)GridView1.Rows[rowindex].FindControl("GridView2");

        Label lbl = (Label)GridView1.Rows[rowindex].FindControl("Label2");

        GridView1.Rows[rowindex].FindControl("Cancel").Visible = false;

        if (e.CommandName == "Details")
        {

            GridView1.Rows[rowindex].FindControl("Cancel").Visible = true;

            GridView1.Rows[rowindex].FindControl("btn_Show").Visible = false;

            SqlConnection con = new SqlConnection(connStr);

            con.Open();

            SqlDataAdapter da = new SqlDataAdapter();

            DataSet ds = new DataSet();

            if (lbl.Text == "ComputerScience")
            {
                da.SelectCommand = new SqlCommand("Select * from ComputerScience", con);
                da.Fill(ds);
            }

            else if (lbl.Text == "Electronics")
            {
                da.SelectCommand = new SqlCommand("Select * from Electronics", con);
                da.Fill(ds);
            }

            else if (lbl.Text == "Electrical")
            {
                da.SelectCommand = new SqlCommand("Select * from Electrical", con);
                da.Fill(ds);
            }

            else
            {

                da.SelectCommand = new SqlCommand("Select * from Mechanical", con);
                da.Fill(ds);

            }
            g2.DataSource = ds;
            g2.DataBind();
            g2.Visible = true;

        }

        else
        {
            g2.Visible = false;
            GridView1.Rows[rowindex].FindControl("btn_Show").Visible = true;
        }
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {

    }
}




     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend