Can we bind 5 lakh records from dataset to gridview...?its throwing error out memory

Question

1.00/5 (1 vote)

See more:

C#

C#4.0

Can we bind 5 lakh records from dataset to gridview...?its throwing error out memory in asp.net

Posted 10-Jul-13 20:45pm

Sunil_Patil

Add a Solution

Comments

Thanks7872 11-Jul-13 2:50am

First of all,it makes no sense to bind 5,00,000 records to gridview at one time.Refine your logic such a way that gets data that needs attention. See,no one can/would like to or be able to go through this much data.So thats of no use.

bbirajdar 11-Jul-13 9:20am

Who is going to read 5 lakh records ?

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)

jaideepsinh · Answer 1 · 2013-07-10T21:04:00

Solution 1

Hello sunil,
This is not a good programming to bind 5lac record to grid view and Why you bind 5lac record at same time make your code and query dynamic. I mean pass page size and how much record you want from data base and create select query depend on this.This why it will take less time to bind and not create any problem.

Posted 10-Jul-13 21:04pm

jaideepsinh

Comments

Sunil_Patil 11-Jul-13 5:27am

bcz i'm going to expoting grid data into excel i cant give paging here at 1 short,data should come in excel

NAGARAJ N MACHAKNUR 11-Jul-13 6:20am

try this,

Bind first 15 or 20 records to grid view provide filtering options. Based on user filtering selection fetch data from SQL then bind data to gridview. User cannot see 5 Lakh records at a time. If you provide filtering option it will be easy for user to see the required data and even it will solve your problem.

Ved Prakash Behera · Answer 2 · 2013-07-11T00:06:00

Solution 2

Please use paging for the Grid. and on the export to excel button click you can write the logic to get all the data and can dump to Excel.

Posted 11-Jul-13 0:06am

Ved Prakash Behera

Comments

Sunil_Patil 11-Jul-13 7:37am

Yes we can change page property in code behind but it will not work while exporting bcz it kills all process so its exporting only how much we mentioned page size