System.OutOfMemoryException exception while retrieving large Data from Database in ASP.Net

Last Reply on Feb 19, 2018 05:23 AM By dharmendr

Posted on Feb 19, 2018 04:34 AM

i want to use jquery datatable in gridview  with 10,00,000 records in asp.net. so hows this possible without taking much of time.

How to use DataTable Jquery Plugin in ASP.Net

Is Datatable load 10,00,000 records easily without fire any MemoryException Error.

 

Posted on Feb 19, 2018 05:23 AM

Hi varun.p,

You can check with the plugin.

But usually when you have large data to DataTable/DataSet your application will throw Out of Memory exception while loading Data.

So to overcome this problem load your data in small amount through custom paging. For this refer below article.

Display Large Amount of Data in GridView with Search functionality in ASP.Net using jQuery