Thank you very much
"Aaron [SQL Server MVP]" wrote:
> You could use XML data islands, or store the pages in HTML. However, this
> won't help when someone runs a search...
> Or, you could use a more efficient paging mechanism.
> (Reverse address to reply.)
> "Serge Myrand" <infosoftdelirium.qc.ca> wrote in message
> news:40E16796.223716FFsoftdelirium.qc.ca...> > Hi,
> > I need an input! I am working on an ASP web application that allow
> > customers to order products from the web site. The products pages show
> > only 20 products at a time, I would like to avoid to requery the table
> > every time the user to navigate between pages (I do not know big the
> > table could be). Is there a way to cache the recordset or a way to make
> > it available "public" from page to page?
> > thank you in advance
> > serge