Using PagedDataSource to Page XML Data

[David Lozzi]

Howdy,

Using .Net 2.0 I am using the PagedDataSource to page through my XML data
source. My question and / or problem is is this opening the XML data source
every time a user clicks through a page or is .Net smart enough to use the
same dataset from the first request? I researched a bit and found how to
cache a dataset, which would be great, and then specify a CacheDependency,
but my problem with this is that the XML data source is actually coming from
a database, IBM's Uniobjects, so I can't specify that as my dependency.

I guess my other option is to use OutputCache for the page itself, however
how do I specify to cache by current page? Everything I'm finding on caching
custom is with the Global.asax file, which I don't need here.

Thanks!!

 

[chris]

David,

I think I asked this same question at the last VSLive conference in
Vegas. We had a SqlDataSource tied to a GridView and we set up
profiler to watch the sql statements execute. I am pretty sure that we
found that the SqlDataSource was pretty smart. (I would say the other
data sources follow suit) The SqlDataSource only went to get refreshed
data from the data store when we Updated/Deleted a record, not when we
paged or sorted.

In your case, you might have to figure a way to step through each call
to watch and see if it is selecting from the data store each time you
click a page.

HTH,
Chris