小女子跪拜求解:在C#中怎样把DataSet中的数据生成CSV文件? 在C#中怎样把DataSet中的数据生成CSV文件?请大哥大姐们鼎立相助!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 /// <summary>/// 将DataSet导出成CSV格式/// </summary>/// <param name="ds">DataSet</param>/// <returns>CSV字符串数据</returns>public static string ExportCSV(DataSet ds){ string data = ""; //data = ds.DataSetName + " "; foreach(DataTable tb in ds.Tables) { data += tb.TableName + " "; //写出列名 foreach (DataColumn column in tb.Columns) { data += column.ColumnName + ","; } data += " "; //写出数据 foreach (DataRow row in tb.Rows) { foreach (DataColumn column in tb.Columns) { data += row[column].ToString() + ","; } data += " "; } data += " "; } return data;} SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]); SqlDataAdapter da=new SqlDataAdapter("select * from tb1",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("自动编号,姓名,年龄"); foreach(DataRow dr in dt.Rows) { sw.WriteLine(dr["ID"]+","+dr["vName"]+","+dr["iAge"]); } sw.Close(); 用正则取出[]中的内容 C# HMAC-SHA1 加密算法 请教各位大哥一个问题 用C#创建Windos Service问题~~~ 初学者请教switch的用法,为什么提示出错,谢谢回答帮助我. sql语句中的表名未知该怎么写? 百分求教Access数据库连接问题,在线等!!!!!急啊!!!!!!!!! 首先向这么晚还在写程序的人致敬,再求一个正则表达式 哪有.net的中文正式版下载? WPF程序停止工作 asp.net 几个基础问题. 百分求解,请高手指点一二!
/// 将DataSet导出成CSV格式
/// </summary>
/// <param name="ds">DataSet</param>
/// <returns>CSV字符串数据</returns>
public static string ExportCSV(DataSet ds)
{
string data = "";
//data = ds.DataSetName + " ";
foreach(DataTable tb in ds.Tables)
{
data += tb.TableName + " ";
//写出列名
foreach (DataColumn column in tb.Columns)
{
data += column.ColumnName + ",";
}
data += " ";
//写出数据
foreach (DataRow row in tb.Rows)
{
foreach (DataColumn column in tb.Columns)
{
data += row[column].ToString() + ",";
}
data += " ";
}
data += " ";
}
return data;
}
SqlDataAdapter da=new SqlDataAdapter("select * from tb1",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("自动编号,姓名,年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["ID"]+","+dr["vName"]+","+dr["iAge"]);
}
sw.Close();