dataset and dataadapter persistance between page loads

[Amadelle]

Hi all and thanks in advance,

I was wondering how to cache/persist a dataset between page loads (after
button clicks, sorts, filters, etc.)? so that i don't have to requery the
database
everytime and create a new dataset and a new dataadapter everytime. I know
that I can use the Session object and store the dataset in a session object,
but I was wondering whether there is a better way of doing this.

I appreciate your help and input in this matter,

Thanks,

Amadelle

 

[John Saunders]

Hi all and thanks in advance,

I was wondering how to cache/persist a dataset between page loads (after
button clicks, sorts, filters, etc.)? so that i don't have to requery the
database
everytime and create a new dataset and a new dataadapter everytime. I know
that I can use the Session object and store the dataset in a session object,
but I was wondering whether there is a better way of doing this.

I appreciate your help and input in this matter,

Session works fine, as long as you're not saving a huge DataSet.