My clients want to see the entire records from my table.
we have given option to our esteemed client as "Export to Excel" (Button Click Event)
This option is working when less than 2 Lakhs records.
If more than 2 Lakhs records then he is getting the error says "Out of memory file stream exception"
What is error and how do we solve this problem..
Steps to perform now as following.
1. Reading the data from Sql table.
2. store the data in data set.
3. using file stream )response.header.etc), save into workbook.
4.download the excel.
The above steps will work only lsess amount of data, if more than 2 lakhs then this will not working.
We are working many applications export to excel option. but, those are very limited data.
thiis is first time we are facing more than 5 lakhs records issues..