本例完成建立缓存,清除缓存使用缓存进行数据绑定
- 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
- {
- //缓存存在执行绑定
- DataSet ds=(DataSet)Cache["DataList"];
- DataGrid1.DataSource=ds;
- DataGrid1.DataBind();
- }
- }