PC Review


Reply
Thread Tools Rate Thread

datagrid paging and XML

 
 
Perre Van Wilrijk
Guest
Posts: n/a
 
      27th Jan 2005
Hi,

Just curious.

If you use the pagingsystem delivered with ASP.NET datagrid control ...

will the system access the database each time you ask the next page ...

or will all data be loaded into a hidden XML-file which will be used when
going to the next page.

If XML is the answer then ...

1) is it stored in memory or on disk
2) when will the file be deleted ... considering IIS doesn't know how long a
user will keep the page in his browser.

Thanks a lot.
--
Kind regards,
Perre Van Wilrijk,
Remove capitals to get my real email address,


 
Reply With Quote
 
 
 
 
Scott M.
Guest
Posts: n/a
 
      27th Jan 2005
Neither will happen.

You would access your data source in the Page_Load event handler in a Non
Postback section of an IF statement and from that point forward, the
DataGrid data is stored in ViewState.

Yes, you will make a trip to the web server each time a new page of data is
requested, but no, you aren't going back to the database for more data each
time.

Depending on the size of the initial data being brought into ViewState in
the first place, you may find that it makes sense to go back to the data
source on each request for a new page of data, the trade off is that you run
more code and access the data source more often, but you are only storing
small amounts of data on any given page request.



"Perre Van Wilrijk" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> Just curious.
>
> If you use the pagingsystem delivered with ASP.NET datagrid control ...
>
> will the system access the database each time you ask the next page ...
>
> or will all data be loaded into a hidden XML-file which will be used when
> going to the next page.
>
> If XML is the answer then ...
>
> 1) is it stored in memory or on disk
> 2) when will the file be deleted ... considering IIS doesn't know how long
> a
> user will keep the page in his browser.
>
> Thanks a lot.
> --
> Kind regards,
> Perre Van Wilrijk,
> Remove capitals to get my real email address,
>
>



 
Reply With Quote
 
Perre Van Wilrijk
Guest
Posts: n/a
 
      28th Jan 2005
Thanks a lot Scott,
Very clear and satisfying answer.

"Scott M." <s-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Neither will happen.
>
> You would access your data source in the Page_Load event handler in a Non
> Postback section of an IF statement and from that point forward, the
> DataGrid data is stored in ViewState.
>
> Yes, you will make a trip to the web server each time a new page of data

is
> requested, but no, you aren't going back to the database for more data

each
> time.
>
> Depending on the size of the initial data being brought into ViewState in
> the first place, you may find that it makes sense to go back to the data
> source on each request for a new page of data, the trade off is that you

run
> more code and access the data source more often, but you are only storing
> small amounts of data on any given page request.
>
>
>
> "Perre Van Wilrijk" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> >
> > Just curious.
> >
> > If you use the pagingsystem delivered with ASP.NET datagrid control ...
> >
> > will the system access the database each time you ask the next page ...
> >
> > or will all data be loaded into a hidden XML-file which will be used

when
> > going to the next page.
> >
> > If XML is the answer then ...
> >
> > 1) is it stored in memory or on disk
> > 2) when will the file be deleted ... considering IIS doesn't know how

long
> > a
> > user will keep the page in his browser.
> >
> > Thanks a lot.
> > --
> > Kind regards,
> > Perre Van Wilrijk,
> > Remove capitals to get my real email address,
> >
> >

>
>



 
Reply With Quote
 
Perre Van Wilrijk
Guest
Posts: n/a
 
      28th Jan 2005
Thanks a lot Scott,
Very clear and satisfying answer,

Perre.

"Scott M." <s-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Neither will happen.
>
> You would access your data source in the Page_Load event handler in a Non
> Postback section of an IF statement and from that point forward, the
> DataGrid data is stored in ViewState.
>
> Yes, you will make a trip to the web server each time a new page of data

is
> requested, but no, you aren't going back to the database for more data

each
> time.
>
> Depending on the size of the initial data being brought into ViewState in
> the first place, you may find that it makes sense to go back to the data
> source on each request for a new page of data, the trade off is that you

run
> more code and access the data source more often, but you are only storing
> small amounts of data on any given page request.
>
>
>
> "Perre Van Wilrijk" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> >
> > Just curious.
> >
> > If you use the pagingsystem delivered with ASP.NET datagrid control ...
> >
> > will the system access the database each time you ask the next page ...
> >
> > or will all data be loaded into a hidden XML-file which will be used

when
> > going to the next page.
> >
> > If XML is the answer then ...
> >
> > 1) is it stored in memory or on disk
> > 2) when will the file be deleted ... considering IIS doesn't know how

long
> > a
> > user will keep the page in his browser.
> >
> > Thanks a lot.
> > --
> > Kind regards,
> > Perre Van Wilrijk,
> > Remove capitals to get my real email address,
> >
> >

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
DataGrid Paging makes DataGrid Disappear smithb1028 Microsoft ASP .NET 7 28th Jan 2007 08:59 PM
DataGrid.Items.Count and DataGrid Paging... Green Start Button Microsoft ASP .NET 1 4th Aug 2005 08:40 PM
Combining numeric mode paging and nextPreview paging in datagrid Red Microsoft ASP .NET 1 12th Mar 2005 11:41 PM
datagrid paging - customising paging style wh1974 Microsoft ASP .NET 0 12th Jan 2005 03:48 PM
datagrid , SQL Reader and Paging... Datagrid disappears Roger Microsoft ASP .NET 0 28th Dec 2004 04:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:05 AM.