Could Anyone explain How to add Header and Subheader in Gridview shown in the below picture!!
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> </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