Skip to content

Instantly share code, notes, and snippets.

View superlucky8848's full-sized avatar

superlucky superlucky8848

  • SuperLucky Works
View GitHub Profile
@superlucky8848
superlucky8848 / DataTableToCSV
Created March 31, 2014 04:33
A easy piece of code for C# to convert DataTable to CSV for Excel import.
public static bool DataTableToCSV(DataTable dtSource, StreamWriter writer, bool includeHeader)
{
if (dtSource == null || writer == null) return false;
if (includeHeader)
{
string[] columnNames = dtSource.Columns.Cast<DataColumn>().Select(column => "\"" + column.ColumnName.Replace("\"", "\"\"") + "\"").ToArray<string>();
writer.WriteLine(String.Join(",", columnNames));
writer.Flush();
}