c# - DataTable to CSV date format -

c# - DataTable to CSV date format -

i'm trying export datatable csv, number of columns. date_time column exported csv while retaining database date_time format (yyy-mm-dd hh:mm:ss), or that.

this code:

private void datatabletocsv(string path, datatable dt) { file.delete(path); 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(path, sb.tostring()); }

the dates appearing in different format, giving me errors when trying pick mysql.

with datetime values, can command output calling

datetimefield.tostring("yyyy-dd-mm");

currently you're treating fields equally, , using default conversion:

field => field.tostring()

you can't specify conversion object.tostring() has no overloads so; you'd have specify conversion utilize each type separately, ie:

string[] fields = row.itemarray.select(field => converttocsvvalue(field)).toarray();

and

static void converttocsvvalue(object value) { if (value datetime) { homecoming ((datetime)value).tostring("yyyy-dd-mm"); } else { homecoming value.tostring(); } }

c# mysql sql .net datatable