How to add Header and Subheader in Gridview

Could Anyone explain How to add Header and Subheader in Gridview shown in the below picture!!

Contents hide

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

hi you can do it like this

<%@ 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="grvMergeHeader" runat="server" 
                      BackColor="LightGoldenrodYellow" 
                      BorderColor="Tan" BorderWidth="5px" 
                      CellPadding="3" ForeColor="Black" 
                      GridLines="None" BorderStyle="None" CellSpacing="2" 
                      AutoGenerateColumns="False" 
                      DataSourceID="SqlDataSource1" 
                      OnRowCreated="grvMergeHeader_RowCreated">
              <FooterStyle BackColor="Tan" />
              <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
              <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" 
                      HorizontalAlign="Center" />
              <HeaderStyle BackColor="Tan" Font-Bold="True" />
              <AlternatingRowStyle BackColor="PaleGoldenrod" />
            <Columns>
                <asp:BoundField DataField="DepartMentID" 
                                HeaderText="DepartMentID" 
                                SortExpression="DepartMentID" />
                <asp:BoundField DataField="DepartMent" 
                                HeaderText="DepartMent" 
                                SortExpression="DepartMent" />
                <asp:BoundField DataField="Name" 
                                HeaderText="Name" 
                                SortExpression="Name" />
                <asp:BoundField DataField="Location" 
                                HeaderText="Location" 
                                SortExpression="Location" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            SelectCommand="SELECT [DepartMentID], [DepartMent], [Name], [Location] FROM [Employee]">
        </asp:SqlDataSource>
        &nbsp;</div>
    </form>
</body>
</html>

Code behind

protected void grvMergeHeader_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            GridView HeaderGrid = (GridView)sender;
            GridViewRow HeaderGridRow = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);
            TableCell HeaderCell = new TableCell();
            HeaderCell.Text = "Department";
            HeaderCell.ColumnSpan = 2;
            HeaderGridRow.Cells.Add(HeaderCell);

            HeaderCell = new TableCell();
            HeaderCell.Text = "Employee";
            HeaderCell.ColumnSpan = 2;
            HeaderGridRow.Cells.Add(HeaderCell);

            grvMergeHeader.Controls[0].Controls.AddAt(0, HeaderGridRow);

        }

Method 2

Here is the nice post check once

http://www.advancesharp.com/blog/1077/gridview-multiple-header-rows

Require Two Header Row in Grid View

http://www.dotnettwitter.com/2010/12/how-to-create-multiple-row-header-and.html

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating