GridView自定义表头和添加合计功能
表格的多行复合表头是在开发中经常遇到的问题,怎么扩展GridView控件以实现多行表头呢
要点:先定义第一行各占多少行,多少列,在追加第二行,以此类推
主体思路是这样的,GridView在ASP.NET中最终是转化为html的表格格式来显示的,所以我们要在其中做点文章,
看下面这段代码:
//在GridView的RowCreated事件中重写表头
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
判断创建的行是不是标题行
if (e.Row.RowType == DataControlRowType.Header)
{
TableCellCollection tcl = e.Row.Cells;
//清除自动生成的表头
tcl.Clear();
//添加新的表头
tcl.Add(new TableHeaderCell());
tcl[0].RowSpan = 2;
tcl[0].Text = "标题s";
Label l1 = new Label();
l1.Text = "uu";
Button bt = new Button();
bt.Text = "1";
//因为自定义表头,所以原来系统中实现的排序功能就失效了
//下面语句可以自己在表头中添加控件,自己实现排序功能
tcl[0].Controls.Add(l1);
tcl[0].Controls.Add(bt);
tcl.Add(new TableHeaderCell());
tcl[1].ColumnSpan = 2;
tcl[1].Text = "标题2";
tcl.Add(new TableHeaderCell());
tcl[2].RowSpan = 2;
tcl[2].Text = "标题3";
tcl.Add(new TableHeaderCell());
tcl[3].ColumnSpan = 3;
tcl[3].Text = "标题4";
tcl.Add(new TableHeaderCell());
tcl[4].RowSpan = 2;
//这段是重点 其实在生成的html中tcl[4]转化为<th>标题5</th>
//所以依照该原则注入html标签来实现,原理有些类似于SQL注入攻击
tcl[4].Text = "标题5</th></tr><tr><th>标题2-1</th><th>标题2-2</th><th>标题4-1</th><th>标题4-2</th><th>标题4-3";
}
}
//添加合计
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView myrows = (DataRowView)e.Row.DataItem;
count1 += Convert.ToDouble(myrows[5].ToString ());
}
if (e.Row.RowType == DataControlRowType.Footer)
{
TableCell c = e.Row.Cells[1];
c.Controls.Clear();
c.Font.Bold = true;
c.Text = "合计";
//添加合计
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView myrows = (DataRowView)e.Row.DataItem;
count1 += Convert.ToDouble(myrows[5].ToString ());
}
if (e.Row.RowType == DataControlRowType.Footer)
{
TableCell c = e.Row.Cells[1];
c.Controls.Clear();
c.Font.Bold = true;
c.Text = "合计";
e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Center;
e.Row.Cells[6].Text = count1.ToString();
e.Row.Cells[6].HorizontalAlign = HorizontalAlign.Center;
}
}
e.Row.Cells[6].HorizontalAlign = HorizontalAlign.Center;
}
}