DataGrid导出到Excel(带分页)
来源:互联网 发布:淘宝联盟官方下载 编辑:程序博客网 时间:2024/05/17 03:37
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();
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();
- DataGrid导出到Excel(带分页)
- DataGrid导出到Excel(带分页)
- 带分页的DataGrid导出到Excel
- DataGrid导出到Excel(带分页)
- datagrid直接导出到excel和分页导出的区别
- DataGrid导出到Excel
- DataGrid导出到Excel
- datagrid 导出到Excel
- Silverlight 中将DataGrid中所有分页导出到Excel
- DataGrid导出到Excel代码
- datagrid数据导出到excel
- 把DataGrid导出到excel
- datagrid导出到excel范例
- DataGrid 控件导出到Excel
- DataGrid数据导出到Excel
- DataGrid导出到excel问题
- wpf导出DataGrid到Excel
- WPF DataGrid导出到Excel
- 如何不通过其他工具,把图片、声音等存储到sql中
- a blue day
- Web Service学习笔记之 JAX-RPC
- Asp.net2.0连接SqlServer200的时候需要注意的问题
- csdn博客
- DataGrid导出到Excel(带分页)
- 总结AJAX相关JS代码片段和浏览器模型
- 用 ASP.Net 发Email
- Keyboard shortcuts for Windows
- hibernate 直接使用 sql 语句
- 使用input type=file 上传文件时需注意
- SQL*PLUS命令的使用大全
- c#的一些字符串的经验
- 动态磁盘&动态卷