GridView导出数据到Excel

来源：互联网发布：金柚网通知去面试编辑：程序博客网时间：2024/04/30 10:06

1、在aspx页面Page标记中设置EnableEventValidation属性

<%@ Page Language="C#" EnableEventValidation = "false" AutoEventWireup="true" CodeFile="OperationLogList.aspx.cs"

Inherits="UserManage_OperationLogList" %>

2、导出数据到Excel

Response.Clear();

Response.Buffer = true;

Response.Charset = "GB2312";

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

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

Response.ContentEncoding = System.Text.Encoding.UTF8;

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

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

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

// 设置GridView控件不可以分页，绑定数据，导出数据到Excel

this.gvLogList.AllowPaging = false;

ExecQuery();

this.gvLogList.RenderControl(oHtmlTextWriter);

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

Response.Flush();

Response.End();

// 设置GridView控件可以分页，重新绑定数据

this.gvLogList.AllowPaging = true;

ExecQuery();

3、重写方法VerifyRenderingInServerForm()，必须有，方法体为空就可以。

public override void VerifyRenderingInServerForm(Control control)

{

}