ASP.NET 緩存Cache使用一例

2010-08-28 10:50:18來源:西部e網(wǎng)作者:

本例完成建立緩存,清除緩存使用緩存進(jìn)行數(shù)據(jù)綁定

public DataSet createCache(){
   //返回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 Button1_Click(object sender, System.EventArgs e)
  {//清除Cache
   Cache.Remove("DataList");
   Response.Write("緩存清除成功");
  }

  private void Button2_Click(object sender, System.EventArgs e)
  {//建立Cache
   if(Cache["DataList"]==null)
   {
    //緩存不存在建立緩存
    Cache.Insert("DataList",(DataSet)createCache());
    DataSet ds=(DataSet)Cache["DataList"];
    DataGrid1.DataSource=ds;
    DataGrid1.DataBind();
   }
   else
   {
    //緩存存在執(zhí)行綁定
    DataSet ds=(DataSet)Cache["DataList"];
    DataGrid1.DataSource=ds;
    DataGrid1.DataBind();
   }
  }

關(guān)鍵詞:ASP.NET