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

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

效果图:



后台代码:
using System;
using
System.Data;
using System.Configuration;
using System.Web;
using
System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using
System.Drawing;
public partial class _Default : System.Web.UI.Page

{
    SqlConnection sqlcon;
    SqlCommand sqlcom;
    string
strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected
void Page_Load(object sender, EventArgs e)
    {
        if
(!IsPostBack)
        {
            bind();
           
       
}
    }
    protected void GridView1_RowEditing(object sender,
GridViewEditEventArgs e)
    {
        GridView1.EditIndex =
e.NewEditIndex;
        bind();
    }
    protected void
GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
   
{
        sqlcon = new SqlConnection(strCon);
        string sqlstr =
"update 飞狐工作室 set 姓名='"
            +
((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim()
+ "',家庭住址='"
            +
((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim()
+ "' where 身份证号码='"
            +
GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcom=new
SqlCommand(sqlstr,sqlcon);
        sqlcon.Open();
       
sqlcom.ExecuteNonQuery();
        sqlcon.Close();
       
GridView1.EditIndex = -1;
        bind();
    }
    protected void
GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
   
{
        GridView1.EditIndex = -1;
        bind();
    }
    public
void bind()
    {
        string sqlstr = "select top 10 * from
飞狐工作室";
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter
myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new
DataSet();
        sqlcon.Open();
        myda.Fill(myds,
"飞狐工作室");
        GridView1.DataSource = myds;
       
GridView1.DataKeyNames = new string[] { "身份证号码" };
       
GridView1.DataBind();
        sqlcon.Close();
    }


//这里就是解决方案
    protected void GridView1_RowCreated(object sender,
GridViewRowEventArgs e)
    {
        switch
(e.Row.RowType)
        {
            case
DataControlRowType.Header:
                //第一行表头
               
TableCellCollection tcHeader = e.Row.Cells;
               
tcHeader.Clear();
                tcHeader.Add(new
TableHeaderCell());
                tcHeader[0].Attributes.Add("rowspan",
"3"); //跨Row
                tcHeader[0].Attributes.Add("bgcolor",
"white");
                tcHeader[0].Text = "";
               
tcHeader.Add(new TableHeaderCell());
               
//tcHeader[1].Attributes.Add("bgcolor", "Red");
               
tcHeader[1].Attributes.Add("colspan", "6"); //跨Column
               
tcHeader[1].Text = "全部信息</th></tr><tr>";


                //第二行表头
                tcHeader.Add(new
TableHeaderCell());
                tcHeader[2].Attributes.Add("bgcolor",
"DarkSeaGreen");
                tcHeader[2].Text =
"身份证号码";
                tcHeader.Add(new
TableHeaderCell());
                tcHeader[3].Attributes.Add("bgcolor",
"LightSteelBlue");
                tcHeader[3].Attributes.Add("colspan",
"2");
                tcHeader[3].Text = "基本信息";
               
tcHeader.Add(new TableHeaderCell());
               
tcHeader[4].Attributes.Add("bgcolor", "DarkSeaGreen");
               
tcHeader[4].Text = "福利";
                tcHeader.Add(new
TableHeaderCell());
                tcHeader[5].Attributes.Add("bgcolor",
"LightSteelBlue");
                tcHeader[5].Attributes.Add("colspan",
"2");
                tcHeader[5].Text =
"联系方式</th></tr><tr>";


                //第三行表头
                tcHeader.Add(new
TableHeaderCell());
                tcHeader[6].Attributes.Add("bgcolor",
"Khaki");
                tcHeader[6].Text = "身份证号码";
               
tcHeader.Add(new TableHeaderCell());
               
tcHeader[7].Attributes.Add("bgcolor", "Khaki");
               
tcHeader[7].Text = "姓名";
                tcHeader.Add(new
TableHeaderCell());
                tcHeader[8].Attributes.Add("bgcolor",
"Khaki");
                tcHeader[8].Text = "出生日期";
               
tcHeader.Add(new TableHeaderCell());
               
tcHeader[9].Attributes.Add("bgcolor", "Khaki");
               
tcHeader[9].Text = "薪水";
                tcHeader.Add(new
TableHeaderCell());
                tcHeader[10].Attributes.Add("bgcolor",
"Khaki");
                tcHeader[10].Text = "家庭住址";
               
tcHeader.Add(new TableHeaderCell());
               
tcHeader[11].Attributes.Add("bgcolor", "Khaki");
               
tcHeader[11].Text = "邮政编码";
                break;
        }
   
}
}

前台:
<!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>GridView合并多重表头表头 清清月儿http://blog.csdn.net/21aspnet
</title>
</head>
<body >
    <form id="form1"
runat="server">
    <div >
                   <asp:GridView
ID="GridView1" runat="server"    AutoGenerateColumns="False" CellPadding="3"
OnRowEditing="GridView1_RowEditing"
                       
OnRowUpdating="GridView1_RowUpdating"
OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White"
BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px"
OnRowCreated="GridView1_RowCreated" >
                       
<FooterStyle BackColor="White" ForeColor="#000066"
/>
                        <Columns>
                           
<asp:CommandField HeaderText="编辑" ShowEditButton="True"
/>
                            <asp:BoundField DataField="身份证号码"
HeaderText="编号" ReadOnly="True" />
                           
<asp:BoundField DataField="姓名" HeaderText="姓名"
/>
                            <asp:BoundField DataField="出生日期"
HeaderText="邮政编码" />
                             <asp:BoundField
DataField="起薪" HeaderText="起薪" />
                           
<asp:BoundField DataField="家庭住址" HeaderText="家庭住址"
/>
                            <asp:BoundField DataField="邮政编码"
HeaderText="邮政编码" />
                          

                        </Columns>
                       
<RowStyle ForeColor="#000066" />
                       
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White"
/>
                        <PagerStyle BackColor="White"
ForeColor="#000066" HorizontalAlign="Left" CssClass="ms-formlabel
DataGridFixedHeader"/>
                        <HeaderStyle
BackColor="#006699" Font-Bold="True" ForeColor="White"
/>
                    </asp:GridView>
        </div>


    </form>
</body>
</html>

posted @   thinksea  阅读(165)  评论(0编辑  收藏  举报
编辑推荐:
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
阅读排行:
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· Docker 太简单,K8s 太复杂?w7panel 让容器管理更轻松!
点击右上角即可分享
微信分享提示