导出为文本文件

using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.IO; using Microsoft.Practices.EnterpriseLibrary.Common; using Microsoft.Practices.EnterpriseLibrary.Data; using System.Data.Common; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dcmd = db.GetSqlStringCommand("SELECT [EmployeeKey],[ParentEmployeeKey],[EmployeeNationalIDAlternateKey],[ParentEmployeeNationalIDAlternateKey],[SalesTerritoryKey],[FirstName] ,[LastName],[MiddleName],[NameStyle],[Title] FROM [DimEmployee]"); DataSet DS =db.ExecuteDataSet(dcmd); ExportToText(DS); } private void ExportToText(DataSet ds) { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Capacity = 100000; if (ds.Tables[0].Rows.Count > 0) { int i = 0; for (int n = 0; n < ds.Tables[0].Rows.Count; n++) { if (n == 0) { for (int j = 0; j < ds.Tables[0].Columns.Count; j++) { if (j + 1 < ds.Tables[0].Columns.Count) { sb.Append(ds.Tables[0].Columns[j].ColumnName + ","); } else { sb.Append(ds.Tables[0].Columns[j].ColumnName + "/r/n"); } } } for (int m = 0; m < ds.Tables[0].Columns.Count; m++) { i++; sb.Append(ds.Tables[0].Rows[n][m].ToString()); if (i % ds.Tables[0].Columns.Count != 0) { sb.Append(":");//列之间分隔符 } else { break; } } sb.Append("/r/n"); } Page.Response.Clear(); Page.Response.Buffer = true; Page.Response.Charset = "GB2312"; Page.Response.AppendHeader("Content-Disposition", "attachment;filename=ExportText.txt"); Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//简体中文 Response.ContentType = "text/plain"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); Page.Response.Write(sb.ToString()); Page.Response.End(); } } }

注:参考网上的代码