从DataTable对象创建CSV

using System;
using System.Data;
using System.IO;

public class Program
{
    public static void Main()
    {
        // 创建一个示例的DataTable对象
        DataTable dataTable = new DataTable();
        dataTable.Columns.Add("Name", typeof(string));
        dataTable.Columns.Add("Age", typeof(int));
        dataTable.Rows.Add("John", 25);
        dataTable.Rows.Add("Jane", 30);
        dataTable.Rows.Add("Tom", 35);

        // 将DataTable对象转换为CSV格式的字符串
        string csvContent = DataTableToCsv(dataTable);

        // 将CSV字符串写入到文件中
        string filePath = "data.csv";
        WriteCsvToFile(csvContent, filePath);

        Console.WriteLine("CSV file created successfully.");
    }

    private static string DataTableToCsv(DataTable dataTable)
    {
        string csv = string.Empty;

        // 添加表头
        foreach (DataColumn column in dataTable.Columns)
        {
            csv += column.ColumnName + ",";
        }
        csv = csv.TrimEnd(',') + Environment.NewLine;

        // 添加数据行
        foreach (DataRow row in dataTable.Rows)
        {
            foreach (var item in row.ItemArray)
            {
                csv += item.ToString() + ",";
            }
            csv = csv.TrimEnd(',') + Environment.NewLine;
        }

        return csv;
    }

    private static void WriteCsvToFile(string csvContent, string filePath)
    {
        File.WriteAllText(filePath, csvContent);
    }
}