private static void exportCSV(String path, String tableName) { CommonDao commonDao = new CommonDao(); SqlDataReader reader = commonDao.getAllData(tableName); StringBuilder sb = new StringBuilder(); StreamWriter sw = new StreamWriter(path + "\\" + tableName + ".csv", false, Encoding.UTF8); //Get All column var columnNames = Enumerable.Range(0, reader.FieldCount) .Select(reader.GetName) //OR .Select("\""+ reader.GetName"\"") .ToList(); //Create headers sb.Append(string.Join(",", columnNames)); //Append Line sb.AppendLine(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { string value = reader[i].ToString(); if (value.Contains(",")) { value = "\"" + value + "\""; } sb.Append(value.Replace(Environment.NewLine, " ") + ","); } sb.Length--; // Remove the last comma sb.AppendLine(); } sw.Write(sb.ToString()); sw.Close(); reader.Close(); }