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

Last Reply one year ago By dharmendr

Posted one year ago

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 one year ago

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