Out of Memory Exception

Question

Dear all I have exported 100000 record to Excel Using DevExpress Control in C#.. So generated Out of Memory Exception .. gridExport.WriteXlsToResponse(); Small of the Record easily exported .. but i have requirement to Export 100000 more record to excel.. give the Solution ASAP..

Rajeev Punhani · Answer

Hi Ronak Please see the below link. https://www.devexpress.com/Support/Center/Question/Details/Q365051 https://documentation.devexpress.com/#AspNet/CustomDocument3726

Nigel Fernandes · Answer

For such large number of records try exporting it as a CSV file.

Bikesh Srivastava · Answer

Hi If you have create any arry size please check and give size dynamic...

Ritesh Singh · Answer

Hi Please check the below nice link: http://www.codeproject.com/Tips/659666/Export-very-large-data-to-Excel-file Note: Please accept the answer if it help you and answer your question. Thanks & Regards Ritesh