关闭

DataGrid导出到Excel(带分页)

1272人阅读 评论(0) 收藏 举报

Response.ContentType = "application/vnd.ms-excel";
   Response.Charset="GB2312";   
   Response.AppendHeader("Content-Disposition","attachment;filename=UpdateDataLog.xls");
   Response.ContentEncoding=System.Text.Encoding.UTF7;  //设置输出流为简体中文
   this.EnableViewState = false;
   System.IO.StringWriter sw = new System.IO.StringWriter();
   System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
   int nCur = this.dgRepair.CurrentPageIndex;
   int nSize = this.dgRepair.PageSize;
   
   this.dgRepair.AllowPaging = false;
   this.RepairBind();
   this.dgRepair.RenderControl(hw);
   //以下恢复分页
   this.dgRepair.AllowPaging = true;
   this.dgRepair.CurrentPageIndex = nCur;
   this.dgRepair.PageSize = nSize;
  //重新绑定DataGrid
   this.RepairBind();
   Response.Write(sw.ToString());
   Response.End();

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:67385次
    • 积分:972
    • 等级:
    • 排名:千里之外
    • 原创:23篇
    • 转载:20篇
    • 译文:0篇
    • 评论:15条
    最新评论