Filling a gridview in asp.net with c# for very huge amount of data as per gridview pagesize.

Question

1.00/5 (2 votes)

See more:

Can anybody please help in filling a gridview in asp.net from a dataset or datatable or datareader fetching huge data from database and allowing the gridview to have paging option and binding the gridview with the amount of data displayable per page and not binding all the data together. Binding the data to the gridview according to the amount of data shown in per page using paging in gridview. Can anybody please help with the entire code for it.

Thank You.

Posted 24-Aug-12 8:36am

sam_roy

Updated 24-Aug-12 8:55am

R. Giskard Reventlov

v2

Add a Solution

Comments

[no name] 24-Aug-12 14:39pm

And what? You want someone to write up all this code for you?

sam_roy 24-Aug-12 15:14pm

no i want the idea to do it. need a guidance to solve it.

R. Giskard Reventlov 24-Aug-12 14:58pm

No one will give you the 'entire code'. Why should they? What have you done so far? Note that loading a huge amount of data is a very bad idea.

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)

**R. Giskard Reventlov** · Answer 1 · 2012-08-24T09:00:00

Solution 1

Start Display Large Amount of Data in GridView with Search Functionality[^].

If only you'd taken a couple of minutes to explore CP you'd see there are few articles that might help.

Posted 24-Aug-12 9:00am

R. Giskard Reventlov

Comments

sam_roy 24-Aug-12 15:05pm

its quite complicated i was looking for a very simple and basic example that will fetch data as per page size and bind that to the gridview not all the data at the sametime. a very simple example. thanks mark i am looking at it. but i would like to have a very basic example implementing the desired functionality.still thanks

R. Giskard Reventlov 24-Aug-12 15:40pm

You have to read, understand and adapt. There is little chance you'll find precisely what you are looking for.

sam_roy 25-Aug-12 2:04am

ok mark i appreciate ur help. thanks

Sandip.Nascar · Answer 2 · 2012-08-24T09:00:00

You are right, get only the data you need instead of all data.

Paging is fine but when it comes to millions of records, be sure to fetch the required subset of data only.

You can provide the record number start with and the maximum records to retrieve from that starting point. This enables you to retrieve only a subset of records from the datasource based on the current page index. All you need is to keep track of the the current record index.

You can store the record index in viewstate or in hidden fields run at = server.

So, while you first load, set the pageindex to 0 and say you display 20 records.
When the next is clicked, update the page index (pageindex++).
Say when you click 8th page, set the page index to 8 and so on.

Now, when you fetch the record from database, pull the data for pageindex 8.
To get the record number,
fromrecord = pageindex*displayrecordno
torecord = fromrecord+displayrecordno

In the e.g. displayrecordno=20

I would prefer reader than datatable and dataset as reader is faser than the other two.

Hope this helps.
cheers