GridView中匯出資料到EXCEL

在GridView中匯出資料到EXCEL 
只要在頁面中添加一個按鈕Button1，給按鈕加上以下代碼即可解決。
protected void Button1_Click(object sender, EventArgs e)
    {
        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();

    }

 

如果有提示 類型“GridView”的控制項 必須放在具有 runat=server 的表單標記內。相關的錯誤就重寫下面一個方法便可。

 public override void VerifyRenderingInServerForm(Control control)
        {
            //   base.VerifyRenderingInServerForm(control);
          
        }