Gridview中的内容导出到Excel
来源:互联网 发布:淘宝vr购物是什么意思 编辑:程序博客网 时间:2024/05/16 09:14
- 在日常工作中,经常要将gridview中的内容导出到excel报表中去,在asp.net 2.0中,同样可以很方便地实现将整个gridview中的内容导出到excel报表中去,下面介绍其具体做法:
- 首先,建立基本的页面default.aspx
- <form id="form1" runat="server">
- <div>
- <asp:GridView ID="GridView1" runat="server">
- </asp:GridView>
- </div>
- <br/>
- <asp:Button ID="BtnExport" runat="server" on_Click="BtnExport_Click"
- Text="Export to Excel" />
- </form>
- 在default.aspx.cs中,写入如下代码:
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!Page.IsPostBack)
- {
- BindData();
- }
- }
- private void BindData()
- {
- string query = "SELECT * FROM customers";
- SqlConnection myConnection = new SqlConnection(ConnectionString);
- SqlDataAdapter ad = new SqlDataAdapter(query, myConnection);
- DataSet ds = new DataSet();
- ad.Fill(ds, "customers");
- GridView1.DataSource = ds;
- GridView1.DataBind();
- }
- public override void VerifyRenderingInServerForm(Control control)
- {
-
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- Response.Clear();
- Response.AddHeader("content-disposition","attachment;filename=FileName.xls");
- Response.Charset = "gb2312";
- Response.ContentType = "application/vnd.xls";
- System.IO.StringWriter stringWrite = new System.IO.StringWriter();
- System.Web.UI.HtmlTextWriter htmlWrite =new HtmlTextWriter(stringWrite);
- GridView1.AllowPaging = false;
- BindData();
- GridView1.RenderControl(htmlWrite);
- Response.Write(stringWrite.ToString());
- Response.End();
- GridView1.AllowPaging = true;
- BindData();
- }
- protected void paging(object sender,GridViewPageEventArgs e)
- {
- GridView1.PageIndex = e.NewPageIndex;
- BindData();
- }
- 在上面的代码中,我们首先将gridview绑定到指定的数据源中,然后在button1的按钮(用来做导出到EXCEL的)的事件中,写入相关的代码。这里使用Response.AddHeader("content-disposition","attachment;filename=exporttoexcel.xls");中的filename来指定将要导出的excel的文件名,这里是exporttoexcel.xls。要注意的是,由于gridview的内容可能是分页显示的,因此,这里在每次导出excel时,先将gridview的allowpaging属性设置为false,然后通过页面流的方式导出当前页的gridview到excel中,最后再重新设置其allowpaging属性。另外要注意的是,要写一个空的VerifyRenderingInServerForm方法(必须写),以确认在运行时为指定的ASP.NET 服务器控件呈现HtmlForm 控件。