System.OutOfMemoryException when binding a gridview to a datatable having more then 400000 records

Question

0.00/5 (No votes)

See more:

Dear,

I am facing system.outofmemmory exception when binding a gridview with a datatable having more then 400000 records please find the below sample code for the same
GridView gv = new GridView();
this.EnableViewState = false;
gv.DataSource = (DataTable)dt;
gv.DataBind();

Kindly help me to overcome in this situation is there any limitation of gridview for databind?

Posted 27-Sep-10 19:53pm

ritranjan

Add a Solution

Comments

Sandeep Mewara 28-Sep-10 16:06pm

Heard of Pagination?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

aidin Tajadod · Answer 1 · 2010-09-28T06:54:00

Solution 1

400000 records in gridview in asp.net!!!! and you want to show it to your user!!
I think you have to reconsider what you are doing.I am not sure if the browsers support this volume of data.
I think it is better to split it in pages.

Posted 28-Sep-10 6:54am

aidin Tajadod

Abhijit Jana · Answer 2 · 2010-09-28T08:18:00

Solution 2

C++

datatable having more then 400000 records please

This is good way show the data in grid. Not, only on grid, I will say anywhere. Did you think about the performace of the page ? And what to do you 400000 data at time. Try to use filter and show only those data which needed. Don't go for showing this amount of huge data.

Posted 28-Sep-10 8:18am

Abhijit Jana

Comments

Sandeep Mewara 28-Sep-10 16:07pm

Looks like he missed that Grid's can have custom pagination...