asp.net Linq把数据导出到Excel的代码

前些时间有朋友为了完成此功能，就硬把数据导入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中两列之间的分隔符号