C#查詢的數據導出到Excel

//有分頁時運用下面方法；

 protected void Button1_Click(object sender, EventArgs e)
    {
        #region  xls導出法  注意在aspx頁面首行添加EnableEventValidation="false"
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");

        Response.Charset = "";
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();

        System.Web.UI.HtmlTextWriter htmlWrite =
        new HtmlTextWriter(stringWrite);

        // turn off paging
        GridView1.AllowPaging = false;
        bind();

        GridView1.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();

        // turn the paging on again
        GridView1.AllowPaging = true;
        bind();
        #endregion
    }
    //如果没有下面方法会报错类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内
    public override void VerifyRenderingInServerForm(Control control)
    {
    }

//無分頁時顯示下面方法；

using System.Text;
using System.IO;

protected void Button1_Click(object sender, EventArgs e)
    {
       
        Export("application/ms-excel", "学生信息报表.xls");

    }
    #region  gridview沒有分頁時所調用的導出方法
    private void Export(string FileType, string FileName)
    {
        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();
    }
    #endregion
    //如果没有下面方法会报错类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内
    public override void VerifyRenderingInServerForm(Control control)
    {
    }

 

 

 

转载于:https://www.cnblogs.com/aliceblogs/archive/2010/06/09/1754891.html