尊敬的会员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