How to download large data from SQL into different file format

Posted by Shivathebravo under Regular Expressions on 5/20/2011 | Points: 10 | Views : 2173 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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?

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

Latest Posts