数据库里面的aa表里有2个字段
aa bb
11 "11,22,33"
22 "22,33,44"
我想把它导成csv格式?
我用了以下程序:
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
SqlDataAdapter da=new SqlDataAdapter("select * from aa",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
DataTable dt=ds.Tables["table1"];
string name=System.Configuration.ConfigurationSettings.AppSettings["downloadurl"].ToString()+DateTime.Today.ToString("yyyyMMdd")+new Random(DateTime.Now.Millisecond).Next(10000).ToString()+".csv";//存放到web.config中downloadurl指定的路径,文件格式为当前日期+4位随机数
FileStream fs=new FileStream(name,FileMode.Create,FileAccess.Write);
StreamWriter sw=new StreamWriter(fs,System.Text.Encoding.GetEncoding("gb2312"));
sw.WriteLine("aa,bb");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["aa"]+","+dr["bb"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(name));
Response.ContentType = "application/ms-excel";// 指定返回的是一个不能被客户端读取的流,必须被下载
Response.WriteFile(name); // 把文件流发送到客户端
Response.End();
但是这样导出来的文件形式是:
A B C D
aa bb
11 " 11 22 33"
22 " 22 33 44"
我想要的效果是:
A B
aa bb
11 " 11,22,33"
22 " 22,33,44" 有办法吗??
bb字段里面有"",
而且我也需要在bb那一列里面有""
我想要里面的值在打开后显示为
bb
" 11,22,33"
在程序里面应该怎么改啊?
aa bb
11 "11,22,33"
22 "22,33,44"
我想把它导成csv格式?
我用了以下程序:
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
SqlDataAdapter da=new SqlDataAdapter("select * from aa",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
DataTable dt=ds.Tables["table1"];
string name=System.Configuration.ConfigurationSettings.AppSettings["downloadurl"].ToString()+DateTime.Today.ToString("yyyyMMdd")+new Random(DateTime.Now.Millisecond).Next(10000).ToString()+".csv";//存放到web.config中downloadurl指定的路径,文件格式为当前日期+4位随机数
FileStream fs=new FileStream(name,FileMode.Create,FileAccess.Write);
StreamWriter sw=new StreamWriter(fs,System.Text.Encoding.GetEncoding("gb2312"));
sw.WriteLine("aa,bb");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["aa"]+","+dr["bb"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(name));
Response.ContentType = "application/ms-excel";// 指定返回的是一个不能被客户端读取的流,必须被下载
Response.WriteFile(name); // 把文件流发送到客户端
Response.End();
但是这样导出来的文件形式是:
A B C D
aa bb
11 " 11 22 33"
22 " 22 33 44"
我想要的效果是:
A B
aa bb
11 " 11,22,33"
22 " 22,33,44" 有办法吗??
bb字段里面有"",
而且我也需要在bb那一列里面有""
我想要里面的值在打开后显示为
bb
" 11,22,33"
在程序里面应该怎么改啊?
试试