How to Export data from SQL database into MS Excel

Question

In my web application i want to download data directly from a SQL database to MS Excel with customize heading. In the web page there will be one textbox, user only choose the date from that textbox(this contain the pop up calender) and when user clicks on download button, it will directly download data into Excel. How can i achieve this?

Check out this link seroter.wordpress.com/2011/03/24/…

Jahan Zinedine
– Jahan Zinedine

2012-01-09 06:51:28 +00:00
Commented Jan 9, 2012 at 6:51 — Jahan Zinedine
– Jahan Zinedine, Commented Jan 9, 2012 at 6:51

Acn · Accepted Answer · 2012-01-09 07:01:24Z

1

You build a dataset from the sql query and conert the dataset to excel file using the code snippet shown in THIS link.

Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=MyFiles.xls");

Now turn off caching, or some browser may unable to download and open the file.

Hope it works for you.

answered Jan 9, 2012 at 7:01

Acn

1,0762 gold badges12 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Megawolt Over a year ago

Simple way, forget the code snippets, just bind a gridview and apply Big Fat Pig's codes... Gridview must be table layoutted

Collectives™ on Stack Overflow

How to Export data from SQL database into MS Excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related