Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > Paging question

Reply
Thread Tools

Paging question

 
 
majiofpersia
Guest
Posts: n/a
 
      07-10-2003
Hi all and thanks in advance for your help,

I am reading this book called ASP.NET unleashed and on the datagrid section
it says that there is a disadvantage with paging with the datagrid. That
when you do paging with the datagrid and datasets, all the records must be
retrieved from the datasource every time you navigate to a new page. So, if
you have a large dataset then that will cause performance problems.

I don't know about this .... it just doesn't sound too right to me.
Specially since datasets are disconnected from the data source. And my
assumption was that they act as containers for the data ... which suggests
to me that once we are using a dataset and datagrid combination, there is no
need to refer back to the data source ...
If this is a known problem, does that mean that this is a bug?

I personally think that the author of the book is wrong, what do you guys
think?

Thanks for your input,

Majiofpersia


 
Reply With Quote
 
 
 
 
Prasad
Guest
Posts: n/a
 
      07-11-2003
Hi

When AllowPaging is set to True for DataGrid. These are the things are
done by the DataGrid :

1. It will Show the Pager UI
2. It will raise OnPageIndexChanged from where we can set
clicked PageIndex

Only the above things are done by the DataGird. Its Developer's
responsible to Bound the Grid and set the PageIndex. So to achieve that we
need to requery the Database everytime and bound it to the grid by setting
PageIndex. For Efficient you can use Programming Logic, or use ASP Caching
features.

HTH
Prasad

"majiofpersia" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all and thanks in advance for your help,
>
> I am reading this book called ASP.NET unleashed and on the datagrid

section
> it says that there is a disadvantage with paging with the datagrid. That
> when you do paging with the datagrid and datasets, all the records must be
> retrieved from the datasource every time you navigate to a new page. So,

if
> you have a large dataset then that will cause performance problems.
>
> I don't know about this .... it just doesn't sound too right to me.
> Specially since datasets are disconnected from the data source. And my
> assumption was that they act as containers for the data ... which suggests
> to me that once we are using a dataset and datagrid combination, there is

no
> need to refer back to the data source ...
> If this is a known problem, does that mean that this is a bug?
>
> I personally think that the author of the book is wrong, what do you guys
> think?
>
> Thanks for your input,
>
> Majiofpersia
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining numeric mode paging and nextPreview paging in datagrid Red ASP .Net 1 03-12-2005 11:41 PM
datagrid paging - customising paging style wh1974 ASP .Net 0 01-12-2005 03:48 PM
DataSet paging vs Datareader paging =?Utf-8?B?UGF0cmljay5PLklnZQ==?= ASP .Net 1 10-08-2004 02:13 PM
Paging Dr. Who, Paging Dr. Who... Father_Sicko@TheOrphanage.com Computer Security 1 07-02-2004 08:59 PM
Dopostback Paging Question jm ASP .Net 0 10-30-2003 04:14 PM



Advertisments