: Always wrap fields in double quotes and escape existing quotes by doubling them ( "" ) to prevent breaking the CSV structure if your data contains commas or newlines.
This method is highly efficient for most console applications because it provides full control over delimiters and character escaping.
: Use Encoding.UTF8 when saving to ensure special characters (like currency symbols or non-English characters) are preserved correctly. Alternative: Using Third-Party Libraries : Always wrap fields in double quotes and
: For very large DataTables, avoid using StringBuilder (which keeps everything in RAM). Instead, write directly to the StreamWriter line-by-line.
To export a DataTable, you must iterate through its columns to create the header row and then loop through the Rows collection to extract the data. 1. Manual Export with StreamWriter Alternative: Using Third-Party Libraries : For very large
using System; using System.Data; using System.IO; using System.Linq; using System.Text; public static void ExportToCsv(DataTable dt, string filePath) { StringBuilder sb = new StringBuilder(); // 1. Create the Header Row IEnumerable columnNames = dt.Columns.Cast (). Select(column => column.ColumnName); sb.AppendLine(string.Join(",", columnNames)); // 2. Add Data Rows foreach (DataRow row in dt.Rows) { IEnumerable fields = row.ItemArray.Select(field => string.Concat("\"", field.ToString().Replace("\"", "\"\""), "\"")); sb.AppendLine(string.Join(",", fields)); } // 3. Save to File File.WriteAllText(filePath, sb.ToString(), Encoding.UTF8); } Use code with caution. Best Practices for Console Applications
If your application requires advanced features like Excel-to-CSV conversion or complex formatting, libraries like or EasyXLS offer one-line methods to save DataTables directly. Core Implementation Method
Exporting a to a CSV file in a C# console application is a common task for data migration, reporting, and backup. While modern .NET versions provide various ways to handle data, the manual approach using StreamWriter remains one of the most efficient and customizable methods without requiring third-party libraries. Core Implementation Method