如何从数据库中成功打印所有数据,如何在Csv文件中打印标题? [英] How Do I Print Header In Csv File While All Data Successfully Printed From Database?
本文介绍了如何从数据库中成功打印所有数据,如何在Csv文件中打印标题?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
听到我的代码....
private void button3_Click( object sender,EventArgs e)
{
StringBuilder sbCSV = new StringBuilder();
int intColCount = dt.Columns.Count;
foreach (DataRowView dr in dt.DefaultView)
{
for ( int x = 0 ; x< intColCount; x ++)
{
sbCSV.Append(dr [x] .ToString());
if ((x + 1 )!= intColCount)
{
sbCSV.Append( ,);
}
}
sbCSV.Append( \\\
跨度>);
}
使用(StreamWriter swr = new StreamWriter( @ C:\ Users\Priya\Desktop\pk.csv))
{
swr.Write(sbCSV.ToString());
}
}
}
帮帮我Plz
thnks提前!!!!
解决方案
您对列的操作也是如此,只需执行一次,显然是在行之前:
foreach (DataColumn col in dt.Columns)
{
sbCSV.Append(col.ColumnName);
// 加上条件冒号(,)东西
}
Hear is my code....
private void button3_Click(object sender, EventArgs e)
{
StringBuilder sbCSV = new StringBuilder();
int intColCount = dt.Columns.Count;
foreach (DataRowView dr in dt.DefaultView)
{
for (int x = 0; x< intColCount; x++)
{
sbCSV.Append(dr[x].ToString());
if ((x + 1) != intColCount)
{
sbCSV.Append(",");
}
}
sbCSV.Append("\n");
}
using (StreamWriter swr = new StreamWriter(@"C:\Users\Priya\Desktop\pk.csv"))
{
swr.Write(sbCSV.ToString());
}
}
}
Help me Plz
thnks on advance!!!!
解决方案
You do the same for the columns as you already do for the rows, just once and obviously before the rows:
foreach(DataColumn col in dt.Columns) { sbCSV.Append(col.ColumnName); // plus the conditional colon (,) stuff }
这篇关于如何从数据库中成功打印所有数据,如何在Csv文件中打印标题?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文