public SqlCacheDependency(string database,string table)

<!--連接數(shù)據(jù)庫(kù)語(yǔ)句-->
 
<configuration>
 <connectionStrings>
  <add name="Config" connectionString="Data Source=.;Initial Catalog=CacheData;Persist Security Info=True;User ID=sa;Password=123" providerName="System.Data.SqlClient"/>
 </connectionStrings>
 
<!--在system.web節(jié)點(diǎn)下添加-->
<!--注意事項(xiàng)：配置中add name值為數(shù)據(jù)庫(kù)名，connectionStringName為連接數(shù)據(jù)庫(kù)字段的名稱要相同-->
 
<caching>
<sqlCacheDependency enabled="true" pollTime="1000">

<databases>
 <add name="CacheData" connectionStringName="Config" pollTime="1000"/>
</databases>
</sqlCacheDependency>

</caching>

private static SqlCacheDependency MyDep;
    protected void Page_Load(object sender, EventArgs e)
    {
      Label1.Text = DateTime.Now.ToString();
      if (!IsPostBack)
      {
        //Cache為數(shù)據(jù)庫(kù)名,T_SqlCache為緩存表
        
        DataSet ds = GetSet();
        if (Cache["SqlCon"] == null)
        {
          //添加緩存SqlCon,緩存值為數(shù)據(jù)庫(kù)表內(nèi)容，
          MyDep = new SqlCacheDependency("Cache", "T_SqlCache");
          Cache.Add("SqlCon", ds, MyDep, DateTime.Now.AddSeconds(60), TimeSpan.Zero, CacheItemPriority.Normal, null);
        } 
        
      }
    }
     
    protected void Button1_Click(object sender, EventArgs e)
    {
      if (MyDep.HasChanged)
      {//當(dāng)數(shù)據(jù)庫(kù)值更改時(shí)提醒；
        Response.Write("數(shù)據(jù)庫(kù)修改時(shí)間為："+MyDep.UtcLastModified);
      }
      if (Cache["SqlCon"] == null)
      {//當(dāng)緩存過期或數(shù)據(jù)庫(kù)值修改后緩存從新加載
        MyDep = new SqlCacheDependency("Ajax", "T_AjaxLD");
        DataSet ds = GetSet();
        Cache.Add("SqlCon", ds, MyDep, DateTime.Now.AddSeconds(60), TimeSpan.Zero, CacheItemPriority.Normal, null);
      }
      this.GridView1.DataSource = Cache["SqlCon"];//綁定數(shù)據(jù)
      this.GridView1.DataBind();
    }
    /// <summary>
    /// 生成Dataset
    /// </summary>
    /// <returns></returns>
    private DataSet GetSet()
    {
      DataSet ds = new DataSet();
      string sql = "select * from T_SqlCache";
      string Config = ConfigurationManager.ConnectionStrings["Config"].ConnectionString;//連接數(shù)據(jù)庫(kù)語(yǔ)句
      using (SqlConnection cnn = new SqlConnection(Config))
      {
        using (SqlCommand cmm = new SqlCommand(sql, cnn))
        {
          SqlDataAdapter dapter = new SqlDataAdapter(cmm);
          dapter.Fill(ds);
        }
      }
 
      return ds;
    }