How do I maintain dataset across page postback without session ?

[anoop s]

Hi,

In my application I need to display reports in datagrid, But need to display only 10 records at a time. I implemented paging by using session. I know it is not a good practice. Some sites suggested to fetch the only records that needed to display. But the problem It is very complicated procedure and will take much more time to run the procedure. How can I avoid the use of Session for storing the heavy ado object. How can I maintain the dataset in the page refresh.
Thanks in advance.

Anoop.

[Frinavale]

There's nothing wrong with storing your data in session or even in ASP.NET's cache.... it's expensive to be making database calls all the time.

I use session or cache all the time to store my data.
When I need paging, the control that I store in session/cache is a DataView. I use this as the source for my GridView.

-Frinny

[anoop s]

Thanks Frinny for your immediate response. But it affects the performance of my application while a number of users are online. Can I clear the particular dataset from session when the page is no more using.

[Frinavale]

Yes you can!
What's stopping you from doing it?

If the data sets can be used by more than one person you can use ASP.NET cache instead....this is accessible to all users.