How Can I Correctly Convert a DataTable to a CSV File in C#?

Efficiently Converting DataTables to CSV in C#

This article demonstrates a robust method for converting C# DataTable objects into comma-separated value (CSV) files. The original method presented issues with proper data separation; this solution provides a corrected and improved approach.

Here's the optimized code:

<code class="language-csharp">StringBuilder sb = new StringBuilder();
IEnumerable<string> columnNames = dt.Columns.Cast<DataColumn>().Select(column => column.ColumnName);
sb.AppendLine(string.Join(",", columnNames));

foreach (DataRow row in dt.Rows)
{
    IEnumerable<string> fields = row.ItemArray.Select(field => field?.ToString() ?? ""); //Handle null values
    sb.AppendLine(string.Join(",", fields));
}

File.WriteAllText("test.csv", sb.ToString());</code>

This code addresses the original issue by correctly separating data into individual cells within the CSV file. It leverages LINQ's Select and string.Join methods to efficiently create the comma-delimited string for both column headers and data rows. The use of File.WriteAllText ensures the CSV data is written to the specified file. The addition of field?.ToString() ?? "" handles potential null values gracefully.

Further enhancements, such as escaping quotes for special characters or memory optimization techniques, can be integrated depending on the specific application needs.

The above is the detailed content of How Can I Correctly Convert a DataTable to a CSV File in C#?. For more information, please follow other related articles on the PHP Chinese website!