dataGrid 多维表头，表头跨行跨列设计

最新推荐文章于 2021-01-30 08:20:45 发布

转载最新推荐文章于 2021-01-30 08:20:45 发布 · 174 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/lweasy/archive/2012/12/18/dataGrid.html

文章标签：

#数据库

dataGrid　其实就是一个ＨＴＭＬ　ＴＡＢＬＥ

想清楚这个以后，要设置多维表头就好办了

ＨＴＭＬ代码

<asp:DataGrid ID="DataGrid1" runat="server"
onitemdatabound="DataGrid1_ItemDataBound">
</asp:DataGrid>

然后绑定数据

protected void Page_Load(object sender, EventArgs e)
        {
            string strsql = "select EmpID, Name, BranchID, LoginID, Pwd, Sex, EmpCode, Email, OfficeTel from mrBaseInf";
            SqlConnection con = new SqlConnection("server=.;database=iOffice2009;uid=sa;pwd=sa");
            DataSet ds = new DataSet();
            SqlDataAdapter ter = new SqlDataAdapter(strsql, con);
            con.Open();
            ter.Fill(ds);
            con.Close();
            this.DataGrid1.DataSource = ds;
            DataGrid1.DataBind();
        }

接下来添加DataGrid1_ItemDataBoun事件

protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
        {
            if (e.Item.ItemType==ListItemType.Header)
            {
                e.Item.Cells[0].RowSpan = 2;
                e.Item.Cells[1].RowSpan = 2;
                e.Item.Cells[2].RowSpan = 2;
                e.Item.Cells[3].RowSpan = 2;
                e.Item.Cells[4].RowSpan = 2;
                e.Item.Cells[5].ColumnSpan = 4;
                e.Item.Cells[5].HorizontalAlign = HorizontalAlign.Center;
                e.Item.Cells[5].Text = "测试</td></tr><tr><td>列1</td><td>列2</td><td>列3</td><td>列4</td></tr>";
                e.Item.Cells[6].Visible = false;
                e.Item.Cells[7].Visible = false;
                e.Item.Cells[8].Visible = false;

            }
        }