62,254
社区成员
发帖
与我相关
我的任务
分享1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11
12 public partial class Demo34 : System.Web.UI.Page
13 {
14 protected void Page_Load(object sender, EventArgs e)
15 {
16 if (Page.IsPostBack == false)
17 {
18 BindData();
19 }
20 }
21
22 public void BindData()
23 {
24 string strSql = "select UserID,C_Name,E_name,UpdataDate,salary,QQ,Zip_Code from Demo_User ";
25 DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.CONN_STRING, CommandType.Text, strSql, null).Tables[0];
26
27 GridView.DataSource = dt;
28 GridView.DataKeyNames = new string[] { "UserID" };//主键
29 GridView.DataBind();
30 }
31
32 protected void GridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
33 {
34 GridView.PageIndex = e.NewPageIndex;
35 BindData();
36 }
37
38 protected void GridView_RowCreated(object sender, GridViewRowEventArgs e)
39 {
40 switch (e.Row.RowType)
41 {
42 case DataControlRowType.Header:
43 //第一行表头
44 TableCellCollection tcHeader = e.Row.Cells;
45 tcHeader.Clear();
46 tcHeader.Add(new TableHeaderCell());
47 tcHeader[0].Attributes.Add("colspan", "6");
48 tcHeader[0].Text = "学生全部信息</th></tr><tr>";
49
50 //第二行表头
51 tcHeader.Add(new TableHeaderCell());
52 tcHeader[1].Text = "基本信息";
53 tcHeader[1].Attributes.Add("colspan", "3");
54 tcHeader.Add(new TableHeaderCell());
55 tcHeader[2].Text = "福利";
56 tcHeader.Add(new TableHeaderCell());
57 tcHeader[3].Attributes.Add("colspan", "2");
58 tcHeader[3].Text = "联系方式</th></tr><tr>";
59
60 //第三行表头
61 tcHeader.Add(new TableHeaderCell());
62 tcHeader[4].Text = "UserID";
63 tcHeader.Add(new TableHeaderCell());
64 tcHeader[5].Text = "中文名字";
65 tcHeader.Add(new TableHeaderCell());
66 tcHeader[6].Text = "英文名字";
67 tcHeader.Add(new TableHeaderCell());
68 tcHeader[7].Text = "薪水";
69 tcHeader.Add(new TableHeaderCell());
70 tcHeader[8].Text = "QQ";
71 tcHeader.Add(new TableHeaderCell());
72 tcHeader[9].Text = "邮政编码";
73 break;
74 }
75 }
76 }
77
1 <table align="center" bgcolor="#c0de98" border="0" cellpadding="0" cellspacing="1" width="99%">
2 <tr>
3 <th colspan="2">
4 GridView演示</th>
5 </tr>
6 <tr>
7 <td colspan="2" style="width: 100%;" >
8 <asp:GridView ID="GridView" runat="server" Width="100%" AutoGenerateColumns="False" AllowPaging="True" OnPageIndexChanging="GridView_PageIndexChanging" PageSize="12" OnRowCreated="GridView_RowCreated" >
9 <Columns>
10 <asp:BoundField DataField="UserID" HeaderText="UserID" />
11 <asp:BoundField DataField="C_Name" HeaderText="中文名字" />
12 <asp:BoundField DataField="E_Name" HeaderText="英文名字" />
13 <asp:BoundField DataField="salary" HeaderText="薪水" DataFormatString="{0:C}" HtmlEncode ="False"/>
14 <asp:BoundField DataField="QQ" HeaderText="QQ" />
15 <asp:BoundField DataField="Zip_Code" HeaderText="邮政编码" />
16 </Columns>
17 <RowStyle HorizontalAlign="Center" />
18 <PagerStyle HorizontalAlign="Center" />
19 </asp:GridView>
20 </td>
21 </tr>
22
23 </table>

protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
switch (e.Row.RowType)
{
//判断是否表头
case DataControlRowType.Header:
//第一行表头
TableCellCollection tcHeader = e.Row.Cells;
tcHeader.Clear();
tcHeader.Add(new TableHeaderCell());
tcHeader[0].Attributes.Add("rowspan", "2");
tcHeader[0].Attributes.Add("bgcolor", "Azure");
tcHeader[0].Text = "编号";
tcHeader.Add(new TableHeaderCell());
tcHeader[1].Attributes.Add("colspan", "6");
tcHeader[1].Attributes.Add("bgcolor", "Azure");
tcHeader[1].Text = "基 本 信 息";
tcHeader.Add(new TableHeaderCell());
tcHeader[2].Attributes.Add("bgcolor", "Azure");
tcHeader[2].Text = "福利</th></tr><tr>";
//第二行表头
tcHeader.Add(new TableHeaderCell());
tcHeader[3].Attributes.Add("bgcolor", "Azure");
tcHeader[3].Text = "账号";
tcHeader.Add(new TableHeaderCell());
tcHeader[4].Attributes.Add("bgcolor", "Azure");
tcHeader[4].Text = "姓名";
tcHeader.Add(new TableHeaderCell());
tcHeader[5].Attributes.Add("bgcolor", "Azure");
tcHeader[5].Text = "性别";
tcHeader.Add(new TableHeaderCell());
tcHeader[6].Attributes.Add("bgcolor", "Azure");
tcHeader[6].Text = "住址";
tcHeader.Add(new TableHeaderCell());
tcHeader[7].Attributes.Add("bgcolor", "Azure");
tcHeader[7].Text = "邮编";
tcHeader.Add(new TableHeaderCell());
tcHeader[8].Attributes.Add("bgcolor", "Azure");
tcHeader[8].Text = "生日";
tcHeader.Add(new TableHeaderCell());
tcHeader[9].Attributes.Add("bgcolor", "Azure");
tcHeader[9].Text = "月薪";
break;
}
}