ASP.NET的GridView在UpdatePanel裡匯出Excel的語句

來源:互聯網
上載者:User
在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()等方法

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.