將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