473,326 Members | 2,099 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,326 software developers and data experts.

dataset and dataadapter persistance between page loads

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
Nov 18 '05 #1
1 1283
"Amadelle" <am******@yahoo.com> wrote in message
news:uj**************@tk2msftngp13.phx.gbl...
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.
--
John Saunders
johnwsaundersiii at hotmail
Nov 18 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Christopher | last post by:
Hi I have the following hardcoded the following (only the relevant code is shown), to populate a datagrid. The data loads into the grid as expected private void LoadData() {
4
by: John Rose | last post by:
I have one databound TextBox on a page with one button. The TextBox loads the correct SQL record data but typing a new string into the Textbox fails to change the DataSet. Any ideas? There must...
2
by: Vinod I | last post by:
Hi Team, I want to use DataSet in my ASP.Net application extensively. Scenario is, I am showing Data Set in one of my ASP.Net Page and changing row & column values thru Page. After that I...
2
by: Bennett Haselton | last post by:
I know how to create a DataAdapter that loads data from a data source into a table in a typed DataSet, and how to set the DataSource and DataMember properties of a DataGrid so that at run time it...
15
by: JIM.H. | last post by:
Hello, Can I send a dataset as a parameter into stored procedure and import data to a table in the stored procedure? Thanks, Jim.
0
by: Shapper | last post by:
Hello, I have a dataset in an ASP.NET/VB web site. Here is the aspx code:
2
by: Kiran | last post by:
Hi, This is something weird I noticed recently in ASP.Net. I have created typed dataset and I have filled the data. when a postback happens, the data of the dataset is lost. Is there a...
11
by: tomp | last post by:
Hi, I am trying to insert a row into the Categories Table in Nothwinds database in MSDE. I am able to manually insert it using a query tool. Using the Debugger, it appears the DataSet loads...
3
by: nashak | last post by:
Hello, ASP.NET pages are disconnected html pages i.e once page is sent to the browser, that is it. Let's say that I have a datagrid on my page and I have used a dataset to fill this grid only...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.