更新时间:2023-10-05 08:22:46
尊敬的会员10868354,
假设你有一个DataTable我想回复你要转换成CSV文件。
在 DataTable 我们有COLUMN HEADER(COLUMN NAME)和数据行。
Dear Member 10868354,
I am answering thing assuming you having one DataTable, that you want to convert into CSV File.
In DataTable we having COLUMN HEADER(COLUMN NAME) and Data Rows.
public static string CSVGenerate(DataTable table)
{
var CSVresult = new StringBuilder();
for (int i = 0; i < table.Columns.Count; i++)
{
CSVresult.Append(table.Columns[i].ColumnName);
CSVresult.Append(i == table.Columns.Count - 1 ? "\n" : ",");
}
foreach (DataRow row in table.Rows)
{
for (int i = 0; i < table.Columns.Count; i++)
{
CSVresult.Append(row[i].ToString());
CSVresult.Append(i == table.Columns.Count - 1 ? "\n" : ",");
}
}
return CSVresult.ToString();
}
table
是传递给我的数据表变量 CSVGenerate 方法。
请试试&检查一下。如果您有任何疑问,请随时联系。
如果您的答案不要忘记标记为答案。
感谢你,
Manoj Kalla
is my datatable variable passed to CSVGenerate method.
Please, Try & Check this.If, you having fruther any query feel free to contact.
If its your answer don't forget to mark as answer.
Thanking You,
Manoj Kalla