using ado between pages

[Guest]

Hello,

I have two.aspx files and so far there are two pages on my web app. On one
page I use a button event to create a dataset and fill/update it from the
MSDE. I have dataadapter, a dataconnection and a dataset on the page with the
button on it. I would like to access the data from the other page. Would I
put the all the ado into cache, application, or session state and then
retrieve them from my second web page? What about inheritance? What would be
the easiest way to retrieve the data on the second web page? Thanks.

 

[Guest]

The application object would only be an option if the dataset is always the
same for every user of the application, based on the assumption that it is
built on a page we're guessing this is not the case for you.

Inheritance will do you no good. The 2 pages will be instantiated but also
destroyed, you want to save the state between the two page calls. This has
nothing to do with class relationships.

Cache could be an option, but we're assuming you want to store the dataset
for every user. Also, you probably don't want the advanced cache capabilities
like reclaiming memory from the cache object when the server is busy.

The session object is probably best suited for you.

Kind regards,
Nikander & Margriet Bruggeman