asp.net Linq把数据导出到Excel的代码
郑家榆人体艺术,黎明之前bt下载,阮经民
前些时间有朋友为了完成此功能,就硬把数据导入datagrid再导出到excel。这实在是多此一举。
解决办法:
通过linq将数据读出,并直接写入数据流中
代码如下:
public partial class datatoexcel : system.web.ui.page
{
protected void page_load(object sender, eventargs e)
{
dataaccess.dataclassesdatacontext db = new dataclassesdatacontext();
var qu = from t in db.txlinfos
select t;
response.appendheader("content-disposition", "attachment;filename=result.xls");
response.contenttype = "application/ms-excel";
response.charset = "gb2312";
response.contentencoding = encoding.getencoding("gb2312");
system.io.stringwriter writer = new system.io.stringwriter();
foreach(txlinfo item in qu)
{
writer.write(item.gqname);
writer.write("\t");
writer.write(item.gqid);
writer.writeline();
}
response.write(writer.tostring());
response.end();
}
}
注:"\t"默认做为excel中两列之间的分隔符号
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!!
点击进行留言回复
网友评论