store data set in session

try
Asp_Question-[Store Dataset in Session Variable][^]
Using Session and Application Objects in ASP.NET, Part 2[^]
Understanding ASP.NET View State[^]

yes you can store dataset in session

while assigning

session["mydataset"]=ds;

while retrieving

dataset ds=(dataset)session["mydataset"];


gridview.datasource=ds.tables[0];
gridview.databind();

Session variable can store large amount of data, including class, dataset.

here is example how we can store dataset in session

Session["objDS"] = objDataset

retrive back to dataset from session variable

dataset objDS =(dataset) session["objDS"]; //it needs casting to dataset

u can save dataset to Session variable as follows:
Session["Table"] = ds.Tables[0];
to retreive it u need not to call again DB just retrieve it from Session as

DataSet ds=new DataSet();
ds = (DataSet)Session["Table"];

// TO Initialize
Session["MyDataSet"] = MyDataSet;
// TO Retrieve
MyRecDataSet = (DataSet) Session["MyDataSet"];

Dim ds as New DataSet
Session("DataSet")=ds