protectedvoidPage_Load(objectsender,EventArgse)
{
if(!Page.IsPostBack)
{
BindData();
}
}
privatevoidBindData()
{
stringquery=/"SELECT*FROMcustomers/";
SqlConnectionmyConnection=newSqlConnection(ConnectionString);
SqlDataAdapterad=newSqlDataAdapter(query,myConnection);
DataSetds=newDataSet();
ad.Fill(ds,/"customers/");
GridView1.DataSource=ds;
GridView1.DataBind();
}
publicoverridevoidVerifyRenderingInServerForm(Controlcontrol)
{
//ConfirmsthatanHtmlFormcontrolisrenderedfor
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
Response.Clear();
Response.AddHeader(/"content-disposition/",/"attachment;filename=FileName.xls/");
Response.Charset=/"gb2312/";
Response.ContentType=/"application/vnd.xls/";
System.IO.StringWriterstringWrite=newSystem.IO.StringWriter();
System.Web.UI.HtmlTextWriterhtmlWrite=newHtmlTextWriter(stringWrite);
GridView1.AllowPaging=false;
BindData();
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
GridView1.AllowPaging=true;
BindData();
}
protectedvoidpaging(objectsender,GridViewPageEventArgse)
{
GridView1.PageIndex=e.NewPageIndex;
BindData();
}
解决方案:
1、在导出界面中重载
publicoverridevoidVerifyRenderingInServerForm(Controlcontrol)
{
//base.VerifyRenderingInServerForm(control);
}
2、在web.config中修改<pagesenableEventValidation=/"false/"></pages>
或
<%@PageLanguage=/"C#/"EnableEventValidation=/"false/"AutoEventWireup=/"true/"
CodeFile=/"ExportGridView.aspx.cs/"Inherits=/"ExportGridView/"%> <script type=text/javascript> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type=text/javascript> </script> <script src="http://googleads.g.doubleclick.net/pagead/test_domain.js"></script> <script src="http://pagead2.googlesyndication.com/pagead/render_ads.js"></script> <script>window.google_render_ad();</script>
{
if(!Page.IsPostBack)
{
BindData();
}
}
privatevoidBindData()
{
stringquery=/"SELECT*FROMcustomers/";
SqlConnectionmyConnection=newSqlConnection(ConnectionString);
SqlDataAdapterad=newSqlDataAdapter(query,myConnection);
DataSetds=newDataSet();
ad.Fill(ds,/"customers/");
GridView1.DataSource=ds;
GridView1.DataBind();
}
publicoverridevoidVerifyRenderingInServerForm(Controlcontrol)
{
//ConfirmsthatanHtmlFormcontrolisrenderedfor
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
Response.Clear();
Response.AddHeader(/"content-disposition/",/"attachment;filename=FileName.xls/");
Response.Charset=/"gb2312/";
Response.ContentType=/"application/vnd.xls/";
System.IO.StringWriterstringWrite=newSystem.IO.StringWriter();
System.Web.UI.HtmlTextWriterhtmlWrite=newHtmlTextWriter(stringWrite);
GridView1.AllowPaging=false;
BindData();
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
GridView1.AllowPaging=true;
BindData();
}
protectedvoidpaging(objectsender,GridViewPageEventArgse)
{
GridView1.PageIndex=e.NewPageIndex;
BindData();
}
解决方案:
1、在导出界面中重载
publicoverridevoidVerifyRenderingInServerForm(Controlcontrol)
{
//base.VerifyRenderingInServerForm(control);
}
2、在web.config中修改<pagesenableEventValidation=/"false/"></pages>
或
<%@PageLanguage=/"C#/"EnableEventValidation=/"false/"AutoEventWireup=/"true/"
CodeFile=/"ExportGridView.aspx.cs/"Inherits=/"ExportGridView/"%> <script type=text/javascript> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type=text/javascript> </script> <script src="http://googleads.g.doubleclick.net/pagead/test_domain.js"></script> <script src="http://pagead2.googlesyndication.com/pagead/render_ads.js"></script> <script>window.google_render_ad();</script>