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 = "合计";

                e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Center;

                e.Row.Cells[6].Text = count1.ToString();
                e.Row.Cells[6].HorizontalAlign = HorizontalAlign.Center;
            }
        }