GridView合并表头多重表头

GridView合并表头多重表头(以合并3列3行举例)
GridView合并表头多重表头无错完美版(以合并3列3行举例)

效果图:

后台代码:

  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using System.Data.SqlClient;
 11using System.Drawing;
 12public partial class _Default : System.Web.UI.Page
 13{
 14    SqlConnection sqlcon;
 15    SqlCommand sqlcom;
 16    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
 17    protected void Page_Load(object sender, EventArgs e)
 18    {
 19        if (!IsPostBack)
 20        {
 21            bind();
 22            
 23        }

 24    }

 25    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
 26    {
 27        GridView1.EditIndex = e.NewEditIndex;
 28        bind();
 29    }

 30    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
 31    {
 32        sqlcon = new SqlConnection(strCon);
 33        string sqlstr = "update 飞狐工作室 set 姓名='"
 34            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',家庭住址='"
 35            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where 身份证号码='" 
 36            + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
 37        sqlcom=new SqlCommand(sqlstr,sqlcon);
 38        sqlcon.Open();
 39        sqlcom.ExecuteNonQuery();
 40        sqlcon.Close();
 41        GridView1.EditIndex = -1;
 42        bind();
 43    }

 44    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
 45    {
 46        GridView1.EditIndex = -1;
 47        bind();
 48    }

 49    public void bind()
 50    {
 51        string sqlstr = "select top 10 * from 飞狐工作室";
 52        sqlcon = new SqlConnection(strCon);
 53        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
 54        DataSet myds = new DataSet();
 55        sqlcon.Open();
 56        myda.Fill(myds, "飞狐工作室");
 57        GridView1.DataSource = myds;
 58        GridView1.DataKeyNames = new string[] { "身份证号码" };
 59        GridView1.DataBind();
 60        sqlcon.Close();
 61    }

 62
 63 //这里就是解决方案
 64    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
 65    {
 66        switch (e.Row.RowType)
 67        {
 68            case DataControlRowType.Header:
 69                //第一行表头
 70                TableCellCollection tcHeader = e.Row.Cells;
 71                tcHeader.Clear();
 72                tcHeader.Add(new TableHeaderCell());
 73                tcHeader[0].Attributes.Add("rowspan", "3"); //跨Row
 74                tcHeader[0].Attributes.Add("bgcolor", "white");
 75                tcHeader[0].Text = "";
 76                tcHeader.Add(new TableHeaderCell());
 77                //tcHeader[1].Attributes.Add("bgcolor", "Red");
 78                tcHeader[1].Attributes.Add("colspan", "6"); //跨Column
 79                tcHeader[1].Text = "全部信息</th></tr><tr>";
 80
 81                //第二行表头
 82                tcHeader.Add(new TableHeaderCell());
 83                tcHeader[2].Attributes.Add("bgcolor", "DarkSeaGreen");
 84                tcHeader[2].Text = "身份证号码";
 85                tcHeader.Add(new TableHeaderCell());
 86                tcHeader[3].Attributes.Add("bgcolor", "LightSteelBlue");
 87                tcHeader[3].Attributes.Add("colspan", "2");
 88                tcHeader[3].Text = "基本信息";
 89                tcHeader.Add(new TableHeaderCell());
 90                tcHeader[4].Attributes.Add("bgcolor", "DarkSeaGreen");
 91                tcHeader[4].Text = "福利";
 92                tcHeader.Add(new TableHeaderCell());
 93                tcHeader[5].Attributes.Add("bgcolor", "LightSteelBlue");
 94                tcHeader[5].Attributes.Add("colspan", "2");
 95                tcHeader[5].Text = "联系方式</th></tr><tr>";
 96
 97                //第三行表头
 98                tcHeader.Add(new TableHeaderCell());
 99                tcHeader[6].Attributes.Add("bgcolor", "Khaki");
100                tcHeader[6].Text = "身份证号码";
101                tcHeader.Add(new TableHeaderCell());
102                tcHeader[7].Attributes.Add("bgcolor", "Khaki");
103                tcHeader[7].Text = "姓名";
104                tcHeader.Add(new TableHeaderCell());
105                tcHeader[8].Attributes.Add("bgcolor", "Khaki");
106                tcHeader[8].Text = "出生日期";
107                tcHeader.Add(new TableHeaderCell());
108                tcHeader[9].Attributes.Add("bgcolor", "Khaki");
109                tcHeader[9].Text = "薪水";
110                tcHeader.Add(new TableHeaderCell());
111                tcHeader[10].Attributes.Add("bgcolor", "Khaki");
112                tcHeader[10].Text = "家庭住址";
113                tcHeader.Add(new TableHeaderCell());
114                tcHeader[11].Attributes.Add("bgcolor", "Khaki");
115                tcHeader[11].Text = "邮政编码";
116                break;
117        }

118    }

119}

前台:

 1<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 2
 3<html xmlns="http://www.w3.org/1999/xhtml" >
 4<head runat="server">
 5    <title>GridView合并多重表头表头 清清月儿http://blog.csdn.net/21aspnet </title>
 6</head>
 7<body >
 8    <form id="form1" runat="server">
 9     <div>
10           <asp:GridView ID="GridView1" runat="server"    AutoGenerateColumns="False" CellPadding="3"  OnRowEditing="GridView1_RowEditing"
11                OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px" OnRowCreated="GridView1_RowCreated"  >
12                <FooterStyle BackColor="White" ForeColor="#000066" />
13                <Columns>
14                    <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
15                    <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
16                    <asp:BoundField DataField="姓名" HeaderText="姓名"  />
17                    <asp:BoundField DataField="出生日期" HeaderText="邮政编码"  />
18                     <asp:BoundField DataField="起薪" HeaderText="起薪"  />
19                    <asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  />
20                    <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" />
21                   
22                </Columns>
23                <RowStyle ForeColor="#000066" />
24                <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
25                <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left"  CssClass="ms-formlabel DataGridFixedHeader"/>
26                <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
27            </asp:GridView>
28        </div>
29    </form>
30</body>
31</html>
原文地址:https://www.cnblogs.com/sherry/p/1239702.html