从gridview导出数据到excel时出错 [英] Getting Error While exporting data from gridview to excel...
问题描述
感谢所有人....
我已经编写了将数据从gridview导出到excel的代码,但我收到了以下错误...我不知道它是什么...请帮助...
错误35''controls_ExcelImportData.VerifyRenderingInServerForm(System.Web.UI.Control)'':找不到合适的方法覆盖
Thanks to all....
I have written the code for exporting data from gridview to excel but i am getting following error...I dont know what is it...please help ...
Error 35 ''controls_ExcelImportData.VerifyRenderingInServerForm(System.Web.UI.Control)'': no suitable method found to override
推荐答案
在onpageload上添加这两行(ExportToExcel是按钮名称)
Add this two line onpageload(ExportToExcel is button name)
ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);
scriptManager.RegisterPostBackControl(this.ExportToExcel);
ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);
scriptManager.RegisterPostBackControl(this.ExportToExcel);
导出网格数据
To export your grid data
public static void ExportToExcel(string strFileName, GridView dg)
{
try
{
HttpContext.Current.Response.ClearContent();
int row = dg.Rows.Count;
HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=" + strFileName + System.DateTime.Now.Hour + "_" + System.DateTime.Now.Minute + ".xls");
HttpContext.Current.Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
dg.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
HttpContext.Current.ApplicationInstance.CompleteRequest();
return;
}
catch(Exception ex)
{
//ex.Message();
}
}
并添加这些行以验证控件的呈现< br $> b $ b
and add these lines as it is to verify rendering of control
public override void VerifyRenderingInServerForm(Control control)
{
/* Verifies that the control is rendered */
}
现在在<%@ page ....%>中的.aspx文件中添加属性
Now In your .aspx file in <%@page .... %> add atributes
AutoEventWireup="true" EnableEventValidation="false"
< br $> b $ b
这对我有用希望对你有帮助..编码快乐: - )
this works for me hope will help you too .. happy coding :-)
This is a common error , you need to override VerifyRenderingInServerForm Method,
http://aspalliance.com/771
将Gridview数据导出到ASP.NET中的Excel [ ^ ]
希望它能帮到你!!
Export Gridview Data to Excel in ASP.NET[^]
Hope it helps u!!
这篇关于从gridview导出数据到excel时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!