DataTable records exports to csv

Question

Hi friends, export datatable to csv c# asp.net ? Please help me on this...

Manoj Bhoir · Answer

Hi, you can write your own extension method to export Datatable to CSV. Please see this code : public static void ToCSV(this DataTable dtDataTable, string strFilePath) { StreamWriter sw = new StreamWriter(strFilePath, false); //headers for (int i = 0; i { sw.Write(dtDataTable.Columns[i]); if (i { sw.Write(","); } } sw.Write(sw.NewLine); foreach (DataRow dr in dtDataTable.Rows) { for (int i = 0; i { if (!Convert.IsDBNull(dr[i])) { string value = dr[i].ToString(); if (value.Contains(',')) { value = String.Format("\"{0}\"", value); sw.Write(value); } else { sw.Write(dr[i].ToString()); } } if (i { sw.Write(","); } } sw.Write(sw.NewLine); } sw.Close(); } Or simplest way : StringBuilder sb = new StringBuilder(); string[] columnNames = dt.Columns.Cast (). 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()); For more details please check these links : Export Datatable to CSV Using Extension Method http://www.c-sharpcorner.com/UploadFile/deveshomar/export-datatable-to-csv-using-extension-method/ http://stackoverflow.com/questions/4959722/c-sharp-datatable-to-csv http://www.codeproject.com/Tips/665519/Writing-a-DataTable-to-a-CSV-file http://www.codeproject.com/Tips/591034/Simplest-code-to-export-a-datatable-into-csv-forma

DataTable records exports to csv

Answers (1)