473,398 Members | 2,120 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

How do I maintain dataset across page postback without session ?

16
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.
Sep 28 '11 #1
3 3387
Frinavale
9,735 Expert Mod 8TB
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
Sep 28 '11 #2
anoop s
16
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.
Sep 29 '11 #3
Frinavale
9,735 Expert Mod 8TB
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.
Sep 29 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Scott | last post by:
I'm trying to set a session variable after displaying a form, then capture the Session variable on postback. For some reason, the below code always returns the form, not the "Step 2" results part....
8
by: ed | last post by:
Does anyone know if ASP.NET 2.0 is going to incorporate "maintain scroll position on postback" in non-IE browsers like Firefox? This seems like an often requested feature on these newsgroups...
5
by: Mark Rodrigues | last post by:
Hi Everyone, I have been fighting a problem for a while and I wonder if someone out there can help. This problem has been presented in a number of news postings previously but I am yet to see a...
5
by: Guadala Harry | last post by:
This has to be easy... I have a DataSet stored in the Session object. I simply need to read it later and get the following error: Cannot implicitly convert type 'object' to 'System.Data.DataSet'...
8
by: Ryu | last post by:
Is there any way to share a DataSet across more than 1 page? Do I have to retrieve the same Dataset everytime I go to a new page? Please advice, thanks
2
by: John Hoge | last post by:
A common problem in database updates in the maintenece of "domain tables". For example, a product database has an option for color. When entering the specifications for a new product, a domain...
5
by: Psych971 | last post by:
Hi, I'm wondering how I can generate a postback using javascript on a page that does not have any controls with the auto-postback property set to true. I know I can just use the submit() function...
9
by: McGeeky | last post by:
Is there a way to get a user control to remember its state across pages? I have a standard page layout I use with a header and footer as user controls. Each page uses the same layout by means of...
5
by: VisionSet | last post by:
Anyone know why this line fails to print anything? document.write(window.top.myWindowArray.name); For that matter, neither does this: document.write('>>' + window.top.myWindowArray.name); ...
0
by: Keithb | last post by:
The maintain scroll position on postback feature works as expected with my site running under localhost on the development machine. When the files are posted to an IIS 6.0 web server running on a...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.