以前datagrid导出为excel，只需如下代码：
Response.Clear();
Response.AddHeader("content-disposition","attachment;filename=FileName.xls");
Response.Charset="";
//IfyouwanttheoptiontoopentheExcelfilewithoutsavingthan
//commentoutthelinebelow
//Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType="application/vnd.xls";
System.IO.StringWriterstringWrite=newSystem.IO.StringWriter();
System.Web.UI.HtmlTextWriterhtmlWrite=newHtmlTextWriter(stringWrite);
gvMaster.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
Response.Clear();Response.AddHeader("content-disposition","attachment;filename=FileName.xls");Response.Charset="";//IfyouwanttheoptiontoopentheExcelfilewithoutsavingthan//commentoutthelinebelow//Response.Cache.SetCacheability(HttpCacheability.NoCache);Response.ContentType="application/vnd.xls";System.IO.StringWriterstringWrite=newSystem.IO.StringWriter();System.Web.UI.HtmlTextWriterhtmlWrite=newHtmlTextWriter(stringWrite);gvMaster.RenderControl(htmlWrite);Response.Write(stringWrite.ToString());Response.End();
现在改成gridview后，以上代码会提示异常错误，经网上搜索，解决方案如下
1、在导出界面中重载
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
2、在web.config中修改
或
<%@PageLanguage="C#"EnableEventValidation="false"AutoEventWireup="true"
CodeFile="ExportGridView.aspx.cs"Inherits="ExportGridView"%>
3、现在可以正常导出了。
评论