ASP.NET按格式导出到TXT文件 （转）

1 SqlConnection con = DB.mysqlconnection();
2         SqlDataAdapter da = new SqlDataAdapter("SQL语句");
3         DataSet ds = new DataSet();
4         da.Fill(ds);
5         System.Text.StringBuilder sb = new System.Text.StringBuilder();
6         if (ds.Tables[0].Rows.Count > 0)
7         {
8             int i = 0;
9             for (int n = 0; n < ds.Tables[0].Rows.Count; n++)
10             {
11                 for (int m = 0; m < ds.Tables[0].Columns.Count; m++)
12                 {
13                     i++;
14                     sb.Append(ds.Tables[0].Rows[n][m].ToString());
15                     if (i % 11 != 0)
16                     {
17                         sb.Append(",");
18                     }
19                     else
20                     { break; }
21                 }
22                 sb.Append("\r\n");
23             }
24             Page.Response.Clear();
25             Page.Response.Buffer = true;
26             Page.Response.Charset = "GB2312";
27             Page.Response.AppendHeader("Content-Disposition", "attachment;filename=abc.txt");
28             Page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
29             Response.ContentType = "text/plain";//设置输出文件类型为txt文件。 
30             this.EnableViewState = false;
31             System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
32             System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
33             Page.Response.Write(sb.ToString());
34             Page.Response.End();
35         }
36         con.Close();

转载于:https://www.cnblogs.com/slcc/archive/2012/03/14/2396187.html