Custom /efficient paging and sorting gridview

Question

5.00/5 (2 votes)

See more: (untagged)

Hi,
Sorry, if this question is stupid but i have tried searching alot and couldn't find an exact answer. Also, i am not looking for an exact solution but guidance in the right direction would be highly appreciated.

I realize that gridview paging selects all data but displays a portion of it. I want to implement custom paging where data is only specific data is selected. I have kind of done my homework on it. ie i can use linq to select and skip data, but i want page links to be displayed at the bottom of the page. Is there any property that sets this (i believe datagrid had virtualitemcount). Does gridview has something like this or do i need to program this portion. I would like to mention here that i don't want to use SqlDataSource or ObjectDataSource, rather i want to assign datatable to gridview.DataSource. Again, would i have to manage paging my self, if i implement above solution.

Sorry, if its a stupid question. Again i found solutions on google but none had numbered pages in bottom of gridview, which i want to have. I can do it with next,prev btn at the moment.

Thankyou very much

Posted 7-Aug-09 17:33pm

mark_me

Add a Solution

1 solution

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.

N a v a n e e t h · Accepted Answer · 2009-08-07T17:59:00

mark_me wrote:
i can use linq to select and skip data

I don't know anything about the problem domain you are working on and data structures you use. But if database is your persisting area, efficient way to do this is to get only rows that will be displayed.

mark_me wrote:
Again i found solutions on google but none had numbered pages in bottom of gridview, which i want to have. I can do it with next,prev btn at the moment.

IMO, there is nothing wrong in using ObjectDataSource since it comes with inbuilt paging capabilities. If you are binding a DataTable, you need to set the TypeName property to DataTable.

You need to provide two methods, one for selecting the data according to the page number and another method for calculating the total count of data. These methods should be assigned to SelectMethod and SelectCountMethod properties respectively.

Scott Guthrie's article[^] gives an overview of doing this. He is using ASP.NET AJAX but the concepts are same.

:)