//ExportCSV public async Task <JsonResult> ExportUsers() { var response = await userService.GetAllExportDetailsAsync(); var dt = response.ExportTable; var sb = new StringBuilder(); foreach (DataColumn col in dt.Columns) { sb.Append(col.ColumnName + ','); } sb.Remove(sb.Length - 1, 1); sb.Append(Environment.NewLine); foreach (DataRow row in dt.Rows) { for (int i = 0; i < dt.Columns.Count; i++) { sb.Append(row[i].ToString().Replace(",", "") + ","); } sb.Append(Environment.NewLine); } string id = Guid.NewGuid().ToString(); string filename = $"users-address-export-{string.Format("{0:yyyy-MM-dd}", DateTime.Today)}.csv"; var myString = sb.ToString(); var myByteArray = System.Text.Encoding.UTF8.GetBytes(myString); var ms = new MemoryStream(myByteArray); ms.Position = 0; TempData[id] = ms.ToArray(); return(Json(new { id, filename })); }