468,249 Members | 1,497 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,249 developers. It's quick & easy.

Are you using the gridview controls automatic paging functionality?

If I have a table with 500.000 records will it be smart to use the
automatic paging functionality included in the gridview control? How
can this work? Does'n the gridview control need to load the whole
table into a datasource and then filter out the page it want to
display? Can somebody explain to me in detail how this work? What about
sorting?

Sep 25 '06 #1
1 1729
Search for "paging" on thecodeproject.com. There is a good article on
there that describes all the different options available to you, and
their benefits. I opted for a stored procedure approach and selecting
the rows into a temp table and returning, this way i'm only grabbing
whatever my pagesize is each time and no more.

ny***********@gmail.com wrote:
If I have a table with 500.000 records will it be smart to use the
automatic paging functionality included in the gridview control? How
can this work? Does'n the gridview control need to load the whole
table into a datasource and then filter out the page it want to
display? Can somebody explain to me in detail how this work? What about
sorting?
Sep 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by davidjgonzalez | last post: by
3 posts views Thread by nyhetsgrupper | last post: by
8 posts views Thread by Greg Lyles | last post: by
5 posts views Thread by Andrew Robinson | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.