A DataSet Question

[Dennis]

I was wondering...Is there a way that a DataSet can be kept available throughout an entire session. I don’t want to keep having to re-query the database for the same data. If it is possible can someone point me in the right direction? Thanks in advance!

[Norman Yuan]

you can just put the DataSet object in a Session object. You do:

private DataSet myDataSet=null;

private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
myDataSet=QueryDatabase(); //method to query database to populate
DataSet
Session["MyData"]=myDataSet;
}
else
{
myDataSet=(DataSet)Session["MyData"];
if (myDataSet==null) //Session may become expired
{
myDataSet=QueryDatabase(); //re-query database when Session
object is gone
}
}
//Do sothing with the data here
}

Of course, you will take it into account that how much data populated into
the DataSet: you do not want to retrieve tens of thousands of records into a
DataSet and then leave them in server's memory.

"Dennis" <ds*********@satisfacts.net> wrote in message
news:99**********************************@microsof t.com...

I was wondering...Is there a way that a DataSet can be kept available

throughout an entire session. I don't want to keep having to re-query the
database for the same data. If it is possible can someone point me in the
right direction? Thanks in advance!

[Norman Yuan]

you can just put the DataSet object in a Session object. You do:

private DataSet myDataSet=null;

private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
myDataSet=QueryDatabase(); //method to query database to populate
DataSet
Session["MyData"]=myDataSet;
}
else
{
myDataSet=(DataSet)Session["MyData"];
if (myDataSet==null) //Session may become expired
{
myDataSet=QueryDatabase(); //re-query database when Session
object is gone
}
}
//Do sothing with the data here
}

Of course, you will take it into account that how much data populated into
the DataSet: you do not want to retrieve tens of thousands of records into a
DataSet and then leave them in server's memory.

"Dennis" <ds*********@satisfacts.net> wrote in message
news:99**********************************@microsof t.com...

I was wondering...Is there a way that a DataSet can be kept available

throughout an entire session. I don't want to keep having to re-query the
database for the same data. If it is possible can someone point me in the
right direction? Thanks in advance!