Export Dataset To Csv File Download In C# ((full)) -

In modern ASP.NET Core MVC or Web API, the most common way to trigger a download is by returning a FileResult .

: In web applications, you can write directly to the Response.Body to start the download before the entire file is even generated. 3. Implementing the Download in ASP.NET Core export dataset to csv file download in c#

[HttpGet("export")] public IActionResult ExportToCSV() { DataTable dt = GetDataFromDatabase(); // Your method to fetch data string csvContent = ConvertToCSV(dt); byte[] buffer = Encoding.UTF8.GetBytes(csvContent); // Returns a browser download prompt return File(buffer, "text/csv", "Report.csv"); } Use code with caution. 4. Using Professional Libraries (CsvHelper) In modern ASP

public string ConvertToCSV(DataTable dt) { StringBuilder sb = new StringBuilder(); // Headers string[] columnNames = dt.Columns.Cast ().Select(column => column.ColumnName).ToArray(); sb.AppendLine(string.Join(",", columnNames)); // Rows foreach (DataRow row in dt.Rows) { string[] fields = row.ItemArray.Select(field => field.ToString()).ToArray(); sb.AppendLine(string.Join(",", fields)); } return sb.ToString(); } Use code with caution. 2. The Scalable Approach: Using StreamWriter Implementing the Download in ASP

: Iterate through the DataTable.Columns to get column names.

: Ensure that values containing commas or line breaks are wrapped in double quotes to maintain CSV integrity.