How to export more than millions of records into pdf files.

Posted by Shivathebravo under Regular Expressions on 6/1/2011 | Points: 10 | Views : 1177 | Status : [Member] | Replies : 1
I need to export more than millions of records from data grid or from sql query directly into different files formats such as .doc,.xls,.pdf,.txt. I was able to download into different file format when my result set was small around 1000 records, but when I query one of my tables which brings more than 1.5 millions of records it started to give me following errors

1 system out of memory.
2)connection timeout

How can I export such large result efficiently without any data loss.


Posted by: Vuyiswamb on: 7/4/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

that is obviously too big to export, why don't you print it directly , because there is no timeout in Printing ?

Thank you for posting at Dotnetfunda

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

Login to post response