How to download large data from SQL into different file format

Posted by Shivathebravo under Regular Expressions on 5/20/2011 | Points: 10 | Views : 1304 | Status : [Member] | Replies : 2
I am working on one of the system that uses SQL server as a beckend and asp.net(C#) as front end. Some of the query that we run pulls more than millions of record. I need to download this record into different file format without timeout issues and without crashing a system while downloading. What is the best way to handle this situation?




Responses

Posted by: Ndebata on: 5/20/2011 [Member] Starter | Points: 25

Up
0
Down
Hi
One way i can suggest use SQL Server Reports to do this.
Just create a report and export it.

Thanks,
Debata

Shivathebravo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prabhakar on: 5/21/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down

Hi Shivathebravo


i think u use fetch ur data in gridview then export it in Excel Format . . easy way . . try it .


http://www.dotnetfunda.com/articles/article1131-export-large-data-from-gridview-to-excel-file-using-csharp-.aspx


Best Regard's
Prabhakar

Shivathebravo, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response