Grid View bind more than 2.5 lacks records

Posted by mareesnectar-12158 under VB.NET on 1/20/2013 | Points: 10 | Views : 1431 | Status : [Member] | Replies : 1

I got the 2.5 lacks records from SQL Database via datatable.
Then I bind the record into Grid View, that time I got "Error: Exception of type 'System.OutOfMemoryException' was thrown."
I used paging also, same error came..

In my project the particular page I want to bind more than 2.5Lacks records.

Please give me the solution...



Posted by: Kundnani.Rt on: 1/20/2013 [Member] Starter | Points: 25

There are two solutions that can be achieved:

1. Do Custom Paging in GridView.

2. Use LINQ-to-SQL Query.

First one is the best option.

mareesnectar-12158, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response