实现GridView中的数据的打印和导出到Excel

最新推荐文章于 2019-04-19 13:42:28 发布

原创最新推荐文章于 2019-04-19 13:42:28 发布 · 2.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#excel #asp #server #object #webbrowser #服务器

本文介绍了一个使用ASP.NET实现的教师花名册页面，该页面利用GridView控件展示教师信息，并实现了分页及导出到Excel的功能。文章还展示了如何在后台代码中进行数据绑定以及响应按钮点击事件来触发打印和导出操作。

MSDN上对 VerifyRenderingInServerForm 方法的解释是:
　　必须位于 <form runat=server> 标记中的控件可以在呈现之前调用此方法，以便在控件被置于标记外时显示错误信息。发送回或依赖于注册的脚本块的控件应该在 Control.Render 方法的重写中调用此方法。呈现服务器窗体元素的方式不同的页可以重写此方法以在不同的条件下引发异常。
　　如果回发或使用客户端脚本的服务器控件没有包含在 HtmlForm 服务器控件 (<form runat="server">) 标记中，它们将无法正常工作。这些控件可以在呈现时调用该方法，以在它们没有包含在 HtmlForm 控件中时提供明确的错误信息。
　　开发自定义服务器控件时，通常在为任何类型的输入标记重写 Render 方法时调用该方法。这在输入控件调用 GetPostBackEventReference 或发出客户端脚本时尤其重要。复合服务器控件不需要作出此调用,没有这个方法，程序将报错。
前台代码:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TeacherReport.aspx.cs" Inherits="TeacherCenter_TeacherReport" %>
2

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4

<html xmlns="http://www.w3.org/1999/xhtml" >
6

<head runat="server">
7

<title>教师花名册</title>
8

</head>
10

<body>
11

width="0">
13

</object>
14

<form id="form1" runat="server">
15

<div style="text-align: center">
16

<table border="0" cellpadding="0" style="text-align: left" width="600">
17

<tr height="23">
18

<td align="center" style="font-size: 25px; height: 23px">
19

临沂市兰山区委党校</td>
20

</tr>
21

<tr height="23">
22

<td align="center" colspan="2" style="font-size: 25px; height: 23px">
23

教师花名册</td>
24

</tr>
25

<tr>
26

<td align="right" colspan="2">
27

<asp:Label ID="lblDateTime" runat="server" Text="lblDateTime" Width="110px"></asp:Label></td>
28

</tr>
29

<tr>
30

<td colspan="2" style="height: 21px" valign="top">
31

 <asp:GridView ID="gvTeacherInfoList" runat="server" AllowPaging="True"
32

AutoGenerateColumns="False"
33

PageSize="40" Width="600px" OnPageIndexChanging="gvTeacherInfoList_PageIndexChanging">
34

<FooterStyle HorizontalAlign="Right" />
35

<Columns>
36

<asp:TemplateField HeaderText="序号">
37

<HeaderTemplate>
38

序号
39

</HeaderTemplate>
40

<ControlStyle Width="10%" />
41

<ItemTemplate>
42

<%#Container.DataItemIndex+1%>
43

</ItemTemplate>
44

</asp:TemplateField>
45

<asp:BoundField DataField="Teacher_Name" HeaderText="姓名" SortExpression="Teacher_Name" />
46

<asp:BoundField DataField="TeacherSex" HeaderText="性别" SortExpression="TeacherSex" />
47

<asp:BoundField DataField="Teacher_Age" HeaderText="年龄" SortExpression="Teacher_Age" />
48

<asp:BoundField DataField="TeacherDuty" HeaderText="职务" SortExpression="TeacherDuty" />
49

<asp:BoundField DataField="Teacher_Speciality" HeaderText="专业" SortExpression="Teacher_Speciality" />
50

<asp:BoundField DataField="Teacher_RelationMode" HeaderText="联系方式" />
51

</Columns>
52

</asp:GridView>
53

</td>
54

</tr>
55

<tr>
56

<td align="right" colspan="2" style="height: 21px" valign="top">
57

<asp:Button ID="btnPrint" runat="server" Text="打印" Width="53px" OnClick="btnPrint_Click" />
58

<asp:Button ID="btnExcel" runat="server" Text="导出到Excel" OnClick="btnExcel_Click" /></td>
59

</tr>
60

</table>
61

</div>
63

</form>
64

</body>
65

</html>
66

后台代码:

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

using System.Data.SqlClient;
12

using Lymit.DistanceEDU.Model;
13

using Lymit.Distanct.Model;
14

using BLL;
15

public partial class TeacherCenter_TeacherReport : System.Web.UI.Page
17

{
18

protected void Page_Load(object sender, EventArgs e)
19

{
20

if (!Page.IsPostBack)
21

{
22

BindTeacherInfo();
23

}
24

this.lblDateTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
25

}
26

private void BindTeacherInfo()
28

{
29

TeacherController tc = TeacherController.GetInstance();
30

string sex = "全部";
31

DataTable dt = tc.GetTeacherRoster(sex);
32

this.gvTeacherInfoList.DataSource = dt.DefaultView;
33

this.gvTeacherInfoList.DataBind();
34

}
35

protected void gvTeacherInfoList_PageIndexChanging(object sender, GridViewPageEventArgs e)
37

{
38

this.gvTeacherInfoList.PageIndex = e.NewPageIndex;
39

BindTeacherInfo();
40

}
41

protected void btnExcel_Click(object sender, EventArgs e)
43

{
44

Response.Clear();
45

Response.Buffer = true;
46

Response.Charset = "GB2312";
47

Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
48

// 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！
49

Response.ContentEncoding = System.Text.Encoding.UTF7;
50

Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
51

System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
52

System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
53

this.gvTeacherInfoList.RenderControl(oHtmlTextWriter);
54

Response.Output.Write(oStringWriter.ToString());
55

Response.Flush();
56

Response.End();
57

}
58

public override void VerifyRenderingInServerForm( Control control )
60

{
61

}
63

protected override void Render(HtmlTextWriter writer)
65

{
66

if (Page != null)
67

{
68

Page.VerifyRenderingInServerForm(this);
69

}
70

base.Render(writer);
71

}
72

protected void btnPrint_Click(object sender, EventArgs e)
73

{
74

Response.Write("<script> window.print()</script>");
75

}
76

}
77