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,

Re: datagrid paging and XML by Scott

Scott
Thu Jan 27 10:32:48 CST 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" <prSPAM@AkoopjeskrantWAY.be> wrote in message
news:16CdnY1BQIgwmGTcRVnyuw@scarlet.biz...
> 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,
>
>



Re: datagrid paging and XML by Perre

Perre
Fri Jan 28 06:02:05 CST 2005

Thanks a lot Scott,
Very clear and satisfying answer,

Perre.

"Scott M." <s-mar@nospam.nospam> wrote in message
news:eJT4S1IBFHA.824@TK2MSFTNGP11.phx.gbl...
> 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" <prSPAM@AkoopjeskrantWAY.be> wrote in message
> news:16CdnY1BQIgwmGTcRVnyuw@scarlet.biz...
> > 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,
> >
> >
>
>



Re: datagrid paging and XML by Perre

Perre
Fri Jan 28 06:02:05 CST 2005

Thanks a lot Scott,
Very clear and satisfying answer.

"Scott M." <s-mar@nospam.nospam> wrote in message
news:eJT4S1IBFHA.824@TK2MSFTNGP11.phx.gbl...
> 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" <prSPAM@AkoopjeskrantWAY.be> wrote in message
> news:16CdnY1BQIgwmGTcRVnyuw@scarlet.biz...
> > 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,
> >
> >
>
>