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(); } }