导出到excel，word，避免了分页导致的导出不全问题

一、定义指令集

    using System.IO;

   using System.Text;

 

二、定义override

 

public override void VerifyRenderingInServerForm(Control control)
    {

    }

 

三、定义按键

   GridView1.AllowPaging = false; //清除分页
        GridView1.DataBind();//分页
        //定义文档类型、字符编码
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        string fileName = "导出测试";

        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName, Encoding.UTF8) + ".doc");
        //解码，防止中文内容时出现乱码，doc换成xls就是导出为excel
        //Response.ContentEncoding = Encoding.GetEncoding("utf-8");
        Response.ContentType = "application/vns-word";
        this.GridView1.EnableViewState = false;
        //　定义一个输入流

        System.IO.StringWriter sw = new  System.IO.StringWriter();
        HtmlTextWriter htmW = new HtmlTextWriter(sw);

        GridView1.RenderControl(htmW);

        Response.Write(sw.ToString());
        GridView1.AllowSorting = true; //恢复分页    

        Response.End();

 

 

清除分页，避免分页数据导出不全。