实现方法就是给单元格填充我们想要的格式代码。
C#
DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
// 计算数据,完全可以从数据看取得
ICollection CreateDataSource( )
{
System.Data.DataTable dt = new System.Data.DataTable();
System.Data.DataRow dr;
dt.Columns.Add(new System.Data.DataColumn("学生班级", typeof(System.String)));
dt.Columns.Add(new System.Data.DataColumn("学生姓名", typeof(System.String)));
dt.Columns.Add(new System.Data.DataColumn("语文", typeof(System.Decimal)));
dt.Columns.Add(new System.Data.DataColumn("数学", typeof(System.Decimal)));
dt.Columns.Add(new System.Data.DataColumn("英语", typeof(System.Decimal)));
dt.Columns.Add(new System.Data.DataColumn("计算机", typeof(System.Decimal)));
for (int i = 0; i < 8; i++)
{
System.Random rd = new System.Random(Environment.TickCount * i); ;
dr = dt.NewRow();
dr[0] = "班级" + i.ToString();
dr[1] = "学生" + i.ToString();
dr[2] = System.Math.Round(rd.NextDouble() * 100, 2);
dr[3] = System.Math.Round(rd.NextDouble() * 100, 2);
dr[4] = System.Math.Round(rd.NextDouble() * 100, 2);
dr[5] = System.Math.Round(rd.NextDouble() * 100, 2);
dt.Rows.Add(dr);
}
System.Data.DataView dv = new System.Data.DataView(dt);
return dv;
}
protected void Page_Load( object sender, EventArgs e )
{
if (!IsPostBack)
{
GridView1.BorderColor = System.Drawing.Color.DarkOrange;
GridView1.DataSource = CreateDataSource();
GridView1.DataBind();
}
}
protected void GridView1_RowCreated( object sender, GridViewRowEventArgs e )
{
if (e.Row.RowType == DataControlRowType.Header)
{
//创建一个GridViewRow,相当于表格的 TR 一行
GridViewRow rowHeader = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
string HeaderBackColor = "#EDEDED";
rowHeader.BackColor = System.Drawing.ColorTranslator.FromHtml(HeaderBackColor);
//实现确定要显示的表头样式,也可以通过计算生成
//
// 关键单元格
// 表头文字
// 表头文字
//
表头文字 |
//
//
// 表头文字
// 表头文字
// 表头文字
//
//
//
表头文字 |
//
表头文字 |
//
表头文字 |
//
表头文字 |
//
表头文字 |
//
// 上面的样式可以设置斜线
Literal newCells = new Literal();
newCells.Text = @"表头文字1
表头文字2
表头文字3
表头文字4 |
---|
" + HeaderBackColor + "'>";
newCells.Text += @"
表头文字5
表头文字6
表头文字7
" + HeaderBackColor + "'>";
newCells.Text += @"
表头文字8 |
---|
表头文字9 |
---|
表头文字10 |
---|
表头文字11 |
---|
表头文字12"; TableCellCollection cells = e.Row.Cells; TableHeaderCell headerCell = new TableHeaderCell(); //下面的属性设置与 关键单元格 要一致 headerCell.RowSpan = 2; headerCell.Controls.Add(newCells); rowHeader.Cells.Add(headerCell); rowHeader.Cells.Add(headerCell); rowHeader.Visible = true; //添加到 GridView1 GridView1.Controls[0].Controls.AddAt(0, rowHeader); } } protected void GridView1_RowDataBound( object sender, GridViewRowEventArgs e ) { if (e.Row.RowType == DataControlRowType.Header) { e.Row.Attributes.Add("style", "background:#9999FF;color:#FFFFFF;font-size:14px"); } else { e.Row.Attributes.Add("style", "background:#FFF"); } } </script> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>为 GridView 添加多层表头</title> </head> <body> <form id="Form1" runat="server"> <asp:GridView ID="GridView1" runat="server" CellSpacing="1" CellPadding="3" Font-Size="12px" Width="600px" BackColor="#000000" BorderWidth="0" OnRowDataBound="GridView1_RowDataBound" OnRowCreated="GridView1_RowCreated"> </asp:GridView> </form> </body> </html> VB.NET DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> Function CreateDataSource() As ICollection Dim dt As System.Data.DataTable = New System.Data.DataTable Dim dr As System.Data.DataRow dt.Columns.Add(New System.Data.DataColumn("学生班级", GetType(System.String))) dt.Columns.Add(New System.Data.DataColumn("学生姓名", GetType(System.String))) dt.Columns.Add(New System.Data.DataColumn("语文", GetType(System.Decimal))) dt.Columns.Add(New System.Data.DataColumn("数学", GetType(System.Decimal))) dt.Columns.Add(New System.Data.DataColumn("英语", GetType(System.Decimal))) dt.Columns.Add(New System.Data.DataColumn("计算机", GetType(System.Decimal))) Dim i As Integer = 0 While i < 8 Dim rd As System.Random = New System.Random(Environment.TickCount * i) dr = dt.NewRow dr(0) = "班级" + i.ToString dr(1) = "学生" + i.ToString dr(2) = System.Math.Round(rd.NextDouble * 100, 2) dr(3) = System.Math.Round(rd.NextDouble * 100, 2) dr(4) = System.Math.Round(rd.NextDouble * 100, 2) dr(5) = System.Math.Round(rd.NextDouble * 100, 2) dt.Rows.Add(dr) System.Math.Min(System.Threading.Interlocked.Increment(i), i - 1) End While Dim dv As System.Data.DataView = New System.Data.DataView(dt) Return dv End Function Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) If Not IsPostBack Then GridView1.BorderColor = System.Drawing.Color.DarkOrange GridView1.DataSource = CreateDataSource() GridView1.DataBind() End If End Sub Protected Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs) If e.Row.RowType = DataControlRowType.Header Then Dim rowHeader As GridViewRow = New GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal) Dim HeaderBackColor As String = "#EDEDED" rowHeader.BackColor = System.Drawing.ColorTranslator.FromHtml(HeaderBackColor) Dim newCells As Literal = New Literal newCells.Text = "表头文字1 |
---|
" 表头文字2" + _
" 表头文字3" + _
"
表头文字4 |
---|
" " + _
" " + HeaderBackColor + "'>" + _
" 表头文字5" + _
" 表头文字6" + _
" 表头文字7" + _
" " + _
" " + HeaderBackColor + "'>" + _
"
表头文字8 |
---|
"
表头文字9 |
---|
"
表头文字10 |
---|
"
表头文字11 |
---|
"
表头文字12" Dim cells As TableCellCollection = e.Row.Cells Dim headerCell As TableHeaderCell = New TableHeaderCell headerCell.RowSpan = 2 headerCell.Controls.Add(newCells) rowHeader.Cells.Add(headerCell) rowHeader.Cells.Add(headerCell) rowHeader.Visible = True GridView1.Controls(0).Controls.AddAt(0, rowHeader) End If End Sub Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs) If e.Row.RowType = DataControlRowType.Header Then e.Row.Attributes.Add("style", "background:#9999FF;color:#FFFFFF;font-size:14px") Else e.Row.Attributes.Add("style", "background:#FFF") End If End Sub </script> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>为 GridView 添加多层表头</title> </head> <body> <form id="Form1" runat="server"> <asp:GridView ID="GridView1" runat="server" CellSpacing="1" CellPadding="3" Font-Size="12px" Width="600px" BackColor="#000000" BorderWidth="0" OnRowDataBound="GridView1_RowDataBound" OnRowCreated="GridView1_RowCreated"> </asp:GridView> </form> </body> </html> |
---|