473,390 Members | 1,723 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,390 software developers and data experts.

Gridview paging

Hi everyone,

I know when you enable paging in a datagrid the entire data is read but
only the data that you want is displayed to the end user. Has this
changed for Gridview? So if you have 10000 records and you only want 20
records displayed, does it read all 10000 and display 20 or does it
only read what it needs (Read 20 and display 20)?

Thanks
MA

May 24 '06 #1
3 2847
It's the latter, paging is implemented with script call backs so that only
the data needed is retrieved.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

"mazdotnet" <ma*******@gmail.com> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...
Hi everyone,

I know when you enable paging in a datagrid the entire data is read but
only the data that you want is displayed to the end user. Has this
changed for Gridview? So if you have 10000 records and you only want 20
records displayed, does it read all 10000 and display 20 or does it
only read what it needs (Read 20 and display 20)?

Thanks
MA

May 25 '06 #2
"Alvin Bruney" <www.lulu.com/owc>'s wild thoughts were
released on Wed, 24 May 2006 21:15:32 -0400 bearing the
following fruit:
It's the latter, paging is implemented with script call backs so that only
the data needed is retrieved.


Are you certain. The Help says this

'If the DetailsView control is bound to a data source
control or to any data structure that implements the
ICollection interface (including datasets), the control gets
all the records from the data source, displays the record
for the current page, and discards the rest. When the user
moves to another page, the DetailsView control repeats the
process, displaying a different record.'

Jan Hyde (VB MVP)

--
Universe: A one stanza poem (Stan Kegel)

May 25 '06 #3
> Are you certain. The Help says this
The help is referring to gridview objects that are bound directly to a
datasource that does not explicitly support paging. Also, the help docs are
correct if the gridview is bound in code via the datasource property.

However, for the reverse, that is, a gridview object that is bound in code
via the datasourceid property or in the instance where the gridview is bound
to a datasource that supports the paging capabilities, the gridview will
retrieve only the the number of records that are required to fill the page.

I was wrong when I said the gridview implemented scripting callbacks, it
doesn't.
--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

"Jan Hyde" <St***********@REMOVE.ME.uboot.com> wrote in message
news:ms********************************@4ax.com...
"Alvin Bruney" <www.lulu.com/owc>'s wild thoughts were
released on Wed, 24 May 2006 21:15:32 -0400 bearing the
following fruit:
It's the latter, paging is implemented with script call backs so that only
the data needed is retrieved.


Are you certain. The Help says this

'If the DetailsView control is bound to a data source
control or to any data structure that implements the
ICollection interface (including datasets), the control gets
all the records from the data source, displays the record
for the current page, and discards the rest. When the user
moves to another page, the DetailsView control repeats the
process, displaying a different record.'

Jan Hyde (VB MVP)

--
Universe: A one stanza poem (Stan Kegel)

May 25 '06 #4

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

Similar topics

0
by: ck388 | last post by:
For some reason when I enable the callback feature of the gridview I still get a page refresh, that is it seems like there is a postback that occurs, not a callback which is just supposed to update...
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...
1
by: davidjgonzalez | last post by:
I have a GridView that has paging enabled. Each item (as defined in an ItemTemplate) includes several controls which have operations i would like to Atlas-enable. Everything is working well except...
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: antonyliu2002 | last post by:
I've been googling for some time, and could not find the solution to this problem. I am testing the paging feature of gridview. I have a very simple web form on which the user can select a few...
5
by: Andrew Robinson | last post by:
I am attempting to better automate a Pager Template within a GridView. I am succesfully skinning a Drop Down List withing my control (the DDL is added to my control). I correctly populate the item...
0
by: Don Miller | last post by:
Here is an example of what I believe is a bug in ASP.NET 2.0 GridView paging without postbacks (or at least not documented how to fix it). Once the GridView is displayed, clicking on any of the...
3
by: Ronald S. Cook | last post by:
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...
4
by: Don Miller | last post by:
This is a repost of a reproducible problem/bug with GridView with dynamic SQL and binding. Is there a better ASP.NET newsgroup I should post to where MS techs or MVPs take an interest in such...
4
by: Peter | last post by:
I want to call a JavaScript on PageIndexChanged event, how do I do that? Thank You Peter
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.