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();
}
