简单实用的.net DataTable导出Execl
datatable导出execl
代码太简单,我们直接看代码。
protected void btnprint_click(object sender, eventargs e)
{
string strpath = "mfout" + datetime.now.tostring("yyyymmddhhmmssfff") + ".xls";
datagrid dg = new datagrid();
dg.datasource = dtmain;
dg.databind();
response.clear();
response.addheader("content-disposition", "attachment;filename=" + strpath + "");
response.charset = "gb2312";
response.contentencoding = system.text.encoding.utf8;//不设置会有乱码
response.contenttype = "application/vnd.xls";
system.io.stringwriter stringwrite = new system.io.stringwriter();
system.web.ui.htmltextwriter htmlwrite = new htmltextwriter(stringwrite);
dg.rendercontrol(htmlwrite);
response.write(stringwrite.tostring());
response.end();
}
public override void verifyrenderinginserverform(control control)
{
//这个方法不能删除掉 导出时要用到,不然会报错:
//类型“gridview”的控件“ctl00_contentplaceholder1_gridview1”必须放在具有 runat=server 的窗体标记内
}
如对本文有疑问,
点击进行留言回复!!
相关文章:
-
-
-
-
-
-
-
-
管理后台无限级菜单
管理后台菜单遍历很久就想做一个通用的管理后台出来,一直太懒没做,今天开始粗略搞了一下,只是先把框架搭建好,菜单栏...
[阅读全文]
-
桥接模式学习总结
桥接模式引言假如一个系统需要加入报表模块,主要的开发点是数据的获取和报表的显示方式。数据的获取可能是从系统数据库...
[阅读全文]
-
-
网友评论