C# mvc file download csv

Flush ; under Response. Write sw ; please check. Deepan Raj Deepan Raj 2 2 silver badges 11 11 bronze badges. This is not a good answer. Please refer to How do I write a good answer? It's a good answer. It's just badly formatted and duplicates the best answer which was posted 6 years earlier. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Introducing Content Health, a new way to keep the knowledge base up-to-date.

Podcast what if you could invest in your favorite developer? Featured on Meta. Now live: A fully responsive profile. Reducing the weight of our footer. This method will extract the necessary data from your database and return the created csv file. For the file name I have added the time stamp so we can see the time which we downloaded the file.

If you have some special characters or unicode characters in data you have to use this kind of UTF encoding. I have added a new Javascript file to my project and added the javascript code to call the action method in controller.

In this script we are reading the url from the link and call the controller method using Ajax. When you add a new js file to your project, you have to register the file in the bundle config file. Please refer to this article to learn how to add custom scripts to a project.

Then the scripts inside the custom js file will be loaded automatically into browser. Make sure to register it after the jquery registration. Otherwise the jquery will give you some errors. Take ToString ,. GetBytes sb. Inside the View, in the very first line the Customer Entity is declared as IEnumerable which specifies that the Model will be available as a Collection.

When this Button will be clicked, the Form is submitted and the Export Action method is called. Column "ContactName" , "Customer Name" ,. Column "City" , "City" ,. Column "Country" , "Country". Exported CSV File. Related Articles. Users may want to get an extract of the data in some form that they can use. There are multiple ways of doing this on client side but users may be seeing only a part of the data on the client.

We decided to serve a comma separated value CSV from the server. In order to serve any type of file from the server, the controller action must return a result of the type FileContentResult as below:.

Knowledge of ASP. Knowledge of HTML. Knowledge of JavaScript. Knowledge of Bootstrap. Knowledge of jQuery. Knowledge of C Programming. You can download the complete source code for this tutorial. The sample code is being developed in Microsoft Visual Studio Professional.