Public dataset createcache (){
// Return Dataset
Dataset DS = new dataset ();
Oledbconnection conn = new oledbconnection
("Provider = Microsoft. Jet. oledb.4.0; Data Source =" + server. mappath ("data. mdb "));
Conn. open ();
String SQL = "select * From data1 order by createtime ASC ";
Oledbdataadapter cmd = new oledbdataadapter (SQL, Conn );
Cmd. Fill (DS );
Cmd. Dispose ();
Conn. Dispose ();
Return Ds;
}
Private void button#click (Object sender, system. eventargs E)
{// Clear Cache
Cache. Remove ("datalist ");
Response. Write ("cache cleared successfully ");
}
private void button2_click (Object sender, system. eventargs e)
{// create a cache
If (Cache ["datalist"] = NULL)
{
// The cache does not exist.
cache. insert ("datalist", (Dataset) createcache ();
dataset DS = (Dataset) cache ["datalist"];
datagrid1.datasource = Ds;
datagrid1.databind ();
}< br> else
{< br> // The cache is bound.
dataset DS = (Dataset) cache ["datalist"];
datagrid1.datasource = Ds;
datagrid1.databind ();
}< BR >}