Back To Blog

.NET and ASP.NET interview questions: - Data exporting from GridView to Excel

By Shiv Prasad Koirala in ASP.NET
Aug 9th, 2011
15405
0

This is one of the most important topics while dealing with GridView data so I thought to share this information.
Let's do a small demonstration to see how exactly we can export data of GridView to Excel in .NET.

In order to Export Data of GridView to Excel you need to follow the following steps.

Step1: - create a new web application for that go to File > New > Project > Select ASP.NET Empty Web Application.

Now, add a WebForm in your application for that justgo to Solution Explorer >Right click on the Project > Add > Add New Item > Select WebForm.

Now, on the WebForm.aspx page just drag and drop GridView control and do the same as
I have done in below code snippet.

Step2: -In this step we will bound the data to the GridView control.

In order to bound the data go to WebForm.aspx.cs and add the below code snippet.

Later just call the method LoadGrid() on form load event like below code snippet.

Step3: - Now again go to WebForm.aspx and add a Button control on the Form and name it as ExportToExcel.

Now on the Button click event just add the below code snippet.

Once you have completed the above steps now just run your application.

As soon as you click on Export to Excel Button a window will pop up like below diagram.