將DataSet數據表導入到EXCEL表格中

 

#region 導入EXCLE功能

        protected void Bt_Creat_Click(object sender, EventArgs e)

        {

            Response.Clear();

            Response.Buffer = true;

            Response.Charset = "UTF-8";

            Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");

            Response.ContentEncoding = System.Text.Encoding.UTF8;

 

            // 設置輸出文件類型為excel文件

            Response.ContentType = "application/ms-excel";

            StringWriter sw = new StringWriter();

            HtmlTextWriter hw = new HtmlTextWriter(sw);

 

            GVControl.RenderControl(hw);

            Response.Output.Write(sw.ToString());

            Response.Flush();

            Response.End();

 

        }

        #endregion

 

如果出現 ” 控件GridView必須放在帶有runat=server的標記表單中 ”

則解決方法是:重載裡面系統自帶的VerifyRenderingInServerForm方法

#region 重載VerifyRenderingInServerForm方法

        public override void VerifyRenderingInServerForm(Control control)

        {

            //base.VerifyRenderingInServerForm(control);

        }

        #endregion

 

分頁報錯:

如果再報錯,解決方案如下:

只能在执行 Render() 的过程中调用问题之解决方案

只能在执行 Render() 的过程中调用 RegisterForEventValidation(RegisterForEventValidation can only be called during Render(); )
当用 GridView 导出 Execl 的时候，会发生只能在执行 Render() 的过程中调用 RegisterForEventValidation 的错误提示。
有两种方法可以解决以上问题：
1. 修改 web.config( 不推荐 )<pages enableEventValidation ="false" ></pages>
2. 直接在导出 Execl 的页面修改
<%@ Page Language="C#"   EnableEventValidation = "false"  AutoEventWireup="true"
CodeFile="ExportGridView.aspx.cs"  Inherits="ExportGridView" %>

 

代碼 :

#region 導入EXCLE功能

        protected void Bt_Creat_Click(object sender, EventArgs e)

        {

 

            GVControl.AllowPaging = false;

            this.GVControl.DataSource = (DataSet)Session["DataView"];

            GVControl.DataBind();

 

            Response.Clear();

            Response.Buffer = true;

 

            Response.Charset = "utf-8";

 

            // 設置輸出文件類型為excel文件

            Response.AddHeader("Content-Disposition", "attachment;filename=FileFlow.xls");

            Response.ContentType = "application/ms-excel";

            StringWriter sw = new StringWriter();

            HtmlTextWriter hw = new HtmlTextWriter(sw);

 

 

            GVControl.RenderControl(hw);

            Response.Write(sw.ToString());

            Response.End();

 

            GVControl.AllowPaging = true;

            this.GVControl.DataSource = (DataSet)Session["DataView"];

            GVControl.DataBind();

 

 

        }

        #endregion