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

publicpartialclassDataToExcel:System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
DataAccess.DataClassesDataContextdb=newDataClassesDataContext();
varqu=fromtindb.TXLInfos
selectt;
Response.AppendHeader("Content-Disposition","attachment;filename=result.xls");
Response.ContentType="application/ms-excel";
Response.Charset="gb2312";
Response.ContentEncoding=Encoding.GetEncoding("gb2312");
System.IO.StringWriterwriter=newSystem.IO.StringWriter();
foreach(TXLInfoiteminqu)
{
writer.Write(item.GQName);
writer.Write("\t");
writer.Write(item.GQID);
writer.WriteLine();
}
Response.Write(writer.ToString());
Response.End();
}
}