在ASP.NET中應用微軟AJAX技術,把GridView在UpdatePanel裡匯出Excel時會出現的錯誤。
就是在ASP.NET2.0架構中當用GridView匯出Execl的時候,會發生只能在執行 Render() 的過程中調用 RegisterForEventValidation的錯誤提示。
方法一:(好像還是不行)
在ajax裡面Response.Write會有衝突,你得為UpdatePanel添加 <triggers> 屬性,把ControlID指嚮導出按扭的ID
<asp:Button ID="Button3" runat="server" Text="匯出Excel" OnClick="Button3_Click" />
</ContentTemplate>
<Triggers>
<asp:PostBackTrigger ControlID="Button3"></asp:PostBackTrigger>
</Triggers>
CS:
protected void Button3_Click(object sender, EventArgs e)
{
Export("application/ms-excel", "產品資訊表.xls");
}
private void Export(string FileType, string FileName)
{
GridView1.EnableViewState = false;
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
GridView1.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
方法二:(可以)
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
// 如果設定為 GetEncoding("GB2312");匯出的檔案將會出現亂碼!!!
Response.ContentEncoding = System.Text.Encoding.UTF7;
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);
this.GridView1.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
}
}
//必須重載此函數
public override void VerifyRenderingInServerForm(Control control)
{ }
方法四:(可能出現亂碼)
public void CreateExcel(DataSet ds, string typeid, string FileName)
{
HttpResponse resp;
resp = Page.Response;
resp.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
string colHeaders = "", ls_item = "";
int i = 0;
//
DataTable dt = ds.Tables[0];
DataRow[] myRow = dt.Select("");
// typeid=="1"為EXCEL文檔;typeid=="2"XML文檔
if (typeid == "1")
{
//
for (i = 0; i < dt.Columns.Count; i++)
{
if (i == dt.Columns.Count - 1)
{
colHeaders += dt.Columns[i].Caption.ToString() + "\n";
}
else
{
colHeaders += dt.Columns[i].Caption.ToString() + "\t";
}
}
//
resp.Write(colHeaders);
//
foreach (DataRow row in myRow)
{
//
for (i = 0; i < dt.Columns.Count; i++)
{
if (i == dt.Columns.Count - 1)
{
ls_item += row[i].ToString() + "\n";
}
else
{
ls_item += row[i].ToString() + "\t";
}
}
//
resp.Write(ls_item);
ls_item = "";
}
}
else
{
if (typeid == "2")
{
//從DataSet中直接匯出XML資料並且寫到HTTP輸出資料流中
resp.Write(ds.GetXml());
}
}
//寫緩衝區中的資料到HTTP標頭檔中
resp.End();
}
調用CreateExcel(ds, "1", "filename.xls");
還有三種方法可以解決以上問題:
1.修改web.config(不推薦)<pages enableEventValidation ="false" ></pages>
2.直接在匯出Execl的頁面修改
<%@ Page Language="C#" EnableEventValidation = "false" AutoEventWireup="true" CodeFile="ExportGridView.aspx.cs" Inherits="ExportGridView" %>
3用ScriptManager.RegisterClientScriptBlock()等方法