从c#中的排序数据表创建多个csv

string outputDirectory = @"C:\CSVFiles";
Directory.CreateDirectory(outputDirectory);

int totalRows = dataTable.Rows.Count;
int numberOfFiles = 5; // 假设要创建5个CSV文件
int rowsPerFile = totalRows / numberOfFiles;

int fileIndex = 1;
int rowIndex = 0;

while (rowIndex < totalRows)
{
    string filePath = Path.Combine(outputDirectory, $"file{fileIndex}.csv");
    
    using (StreamWriter writer = new StreamWriter(filePath))
    {
        for (int i = 0; i < rowsPerFile && rowIndex < totalRows; i++)
        {
            DataRow row = dataTable.Rows[rowIndex];
            
            // 将数据写入CSV文件
            string csvLine = string.Join(",", row.ItemArray);
            writer.WriteLine(csvLine);
            
            rowIndex++;
        }
    }
    
    fileIndex++;
}