C# DataTable to CSV
.Net 3.5 StringBuilder sb = new StringBuilder(); string [] columnNames = dt.Columns.Cast<DataColumn>(). Select(column => column.ColumnName). ToArray(); sb.AppendLine( string .Join( "," , columnNames)); foreach (DataRow row in dt.Rows) { string [] fields = row.ItemArray.Select(field => field.ToString()). ToArray(); sb.AppendLine( string .Join( "," , fields)); } File.WriteAllText( "test.csv" , sb.ToString()); .Net 4 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()); sb.AppendLine( string .Join