473,241 Members | 1,849 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

Does GridView paging feature limit number of records coming back from database?

I was told that if calling lots of records from the database (let's say
100,000), that the GridView's paging feature would automatically "handle"
everything.
But the 100,000 records are still coming to the client, right? I mean, the
paging feature isn't somehow making calls to the database for 25 records at
a time or anything like that is it?

I remember in the past having to write nasty stored procedures that took in
what the last record was and how many to return to manually handle this sort
of thing without dumping 100,000 records all at once.

But does the GridView's paging feature truly do this?

Thanks for any insight,
Ron
Apr 15 '07 #1
3 3711
Hi,

You are correct, the standard paging does not reduce the server side result
set. And you need to use custom paging to achieve a more optimal solution
esp. for very large result sets. Of course SQL Server 2005 offers very nice
feature to support paging of queries.

Hope this helps

--
Chris Taylor
http://dotnetjunkies.com/weblog/chris.taylor
"Ronald S. Cook" <rc***@westinis.comwrote in message
news:ey**************@TK2MSFTNGP03.phx.gbl...
>I was told that if calling lots of records from the database (let's say
100,000), that the GridView's paging feature would automatically "handle"
everything.
But the 100,000 records are still coming to the client, right? I mean,
the paging feature isn't somehow making calls to the database for 25
records at a time or anything like that is it?

I remember in the past having to write nasty stored procedures that took
in what the last record was and how many to return to manually handle this
sort of thing without dumping 100,000 records all at once.

But does the GridView's paging feature truly do this?

Thanks for any insight,
Ron

Apr 15 '07 #2
you can use dataset for such a feature
in .net 2005 it supports
you can call da.fill(ds,starting indx, number of records ,and
somenthin)
May 6 '07 #3
On Apr 15, 8:16 pm, "Chris Taylor" <chris_taylor...@hotmail.com>
wrote:
Hi,

You are correct, the standard paging does not reduce the server side result
set. And you need to use custom paging to achieve a more optimal solution
esp. for very large result sets. Of course SQL Server 2005 offers very nice
feature to support paging of queries.

Hope this helps

--
Chris Taylorhttp://dotnetjunkies.com/weblog/chris.taylor

"Ronald S. Cook" <r...@westinis.comwrote in messagenews:ey**************@TK2MSFTNGP03.phx.gbl. ..
I was told that if calling lots of records from the database (let's say
100,000), that the GridView's paging feature would automatically "handle"
everything.
But the 100,000 records are still coming to the client, right? I mean,
the paging feature isn't somehow making calls to the database for 25
records at a time or anything like that is it?
I remember in the past having to write nasty stored procedures that took
in what the last record was and how many to return to manually handle this
sort of thing without dumping 100,000 records all at once.
But does the GridView's paging feature truly do this?
Thanks for any insight,
Ron- Hide quoted text -

- Show quoted text -
Note, the GridView does an optimized paging with the ObjectDataSource
control.

How Paging Works in the GridView Control
http://msdn2.microsoft.com/en-us/library/5aw1xfh3.aspx

May 6 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: karunakar rao | last post by:
Hi All I need some help. I have been populated 50,000 Records in asp.net C# datagrid. Ever page has 10 records Example "<< Prev 1 2 3 4 5 6 7 8 9 10 Next>> Iam showing like that in my...
4
by: news.microsoft.com | last post by:
I've looked in the help and at each of the properties for the grid view, but can't seem to find what I need. I have allowpaging set to true for my gridview and when the page loads I go and fetch...
2
by: | last post by:
Hello, I have a GridView in my ASP.NET 2.0 application that performs the paging feature perfect when I have it bound to a data source. But now I have it bound to a dataset and the paging...
8
by: AG | last post by:
ASP.NET 2.0, VS 2005 I have a gridview with paging enabled, bound to an objectdatasource. Both were dropped on to the page and configured via the wizards. Basically working as expected. The...
8
by: Greg Lyles | last post by:
Hi all, I'm trying to develop an ASP.NET 2.0 website and am running into some real problems with what I thought would be a relatively simple thing to do. In a nutshell, I'm stuck on trying to...
2
by: rn5a | last post by:
In a shopping cart app, a ASPX page retrieves the order details & personal details of a user from a MS-Access database table depending upon the username of the user. The order details of a...
0
by: news.ipartners.pl | last post by:
Hello, I've run across problem with paging in gridview. I have 2 elementson my web page - drop down list filled with manufacturers and grid view for displaying data connected with certain...
7
by: underground | last post by:
I have a problem that I've spent countless hours on and I'm more than certain this is a obviuos issue to an expert but I am still learning. I have a paging script that I have modified to display a...
1
by: rbrowning1958 | last post by:
Hello, I wonder whether someone can explain to me how data is fetched from a database server when using ASP.NET 2.0's gridview with paging enabled? My SQL DataSource has a simple "select * from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.