当前位置:Gxlcms > asp.net > dataGrid 多维表头、表头跨行跨列设计及绑定数据

dataGrid 多维表头、表头跨行跨列设计及绑定数据

时间:2021-07-01 10:21:17 帮助过:52人阅读

dataGrid 其实就是一个html table 
想清楚这个以后,要设置多维表头就好办了
html代码
代码如下:
  1. <br><asp:DataGrid ID="DataGrid1" runat="server" <br>onitemdatabound="DataGrid1_ItemDataBound"> <br></asp:DataGrid> <br> <br>然后绑定数据 <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>protected void Page_Load(object sender, EventArgs e) <br>{ <br>string strsql = "select EmpID, Name, BranchID, LoginID, Pwd, Sex, EmpCode, Email, OfficeTel from mrBaseInf"; <br>SqlConnection con = new SqlConnection("server=.;database=iOffice2009;uid=sa;pwd=sa"); <br>DataSet ds = new DataSet(); <br>SqlDataAdapter ter = new SqlDataAdapter(strsql, con); <br>con.Open(); <br>ter.Fill(ds); <br>con.Close(); <br>this.DataGrid1.DataSource = ds; <br>DataGrid1.DataBind(); <br>} <br> <br>接下来添加DataGrid1_ItemDataBoun事件 <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e) <br>{ <br>if (e.Item.ItemType==ListItemType.Header) <br>{ <br>e.Item.Cells[0].RowSpan = 2; <br>e.Item.Cells[1].RowSpan = 2; <br>e.Item.Cells[2].RowSpan = 2; <br>e.Item.Cells[3].RowSpan = 2; <br>e.Item.Cells[4].RowSpan = 2; <br>e.Item.Cells[5].ColumnSpan = 4; <br>e.Item.Cells[5].HorizontalAlign = HorizontalAlign.Center; <br>e.Item.Cells[5].Text = "测试</td></tr><tr><td>列1</td><td>列2</td><td>列3</td><td>列4</td></tr>"; <br>e.Item.Cells[6].Visible = false; <br>e.Item.Cells[7].Visible = false; <br>e.Item.Cells[8].Visible = false; <br>} <br>} <br> <br>效果图 <br><img height="103" src="https://img.gxlcms.com//Uploads-s/new/2019-09-19-201919/20121220144810896.jpg" width="764"></li><li> </li><li> </li></ol></pre></li></ol></pre>

人气教程排行