Export: Datatable To Csv File Download In C# [exclusive]

To trigger a file download in a browser, you must modify the HTTP response headers.

: Set this header to attachment; filename=Export.csv to tell the browser to download the file rather than display it. Content-Type : Use text/csv or application/text . export datatable to csv file download in c#

public static void ExportToCsv(DataTable dt, string filePath) { StringBuilder sb = new StringBuilder(); // Write Column Headers IEnumerable columnNames = dt.Columns.Cast ().Select(column => column.ColumnName); sb.AppendLine(string.Join(",", columnNames)); // Write Row Data foreach (DataRow row in dt.Rows) { IEnumerable fields = row.ItemArray.Select(field => string.Concat("\"", field.ToString().Replace("\"", "\"\""), "\"")); sb.AppendLine(string.Join(",", fields)); } File.WriteAllText(filePath, sb.ToString()); } Use code with caution. 2. Exporting for Web Download (ASP.NET / Web API) To trigger a file download in a browser,

: Iterate through DataTable.Rows and join cell values with a delimiter (usually a comma). export datatable to csv file download in c#