dataset 导出excel或者word的例子

最新推荐文章于 2021-02-25 17:43:50 发布

anku0825

最新推荐文章于 2021-02-25 17:43:50 发布

阅读量116

点赞数

原文链接：http://www.cnblogs.com/zhdonghu/archive/2010/06/20/1761516.html

版权

protected void Button3_Click(object sender, EventArgs e)
    {
        ExportDataGrid("application/ms-excel", "城市品牌报表.xls");
    }

    private void ExportDataGrid(string FileType, string FileName)        //从DataGrid导出
    {
        Response.Charset = "GB2312";

        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

        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);


        this.GV_city.RenderControl(hw);

        Response.Write(tw.ToString());
        Response.End();
    }
    public override void VerifyRenderingInServerForm(Control control)//重载该方法确保正常保存
    {
        //base.VerifyRenderingInServerForm(control);