缓存失效的三种方式_c# cache.insert-CSDN博客

本文链接：https://blog.csdn.net/liu_111111/article/details/9083751

-----------------------WebFrom1.aspx---------------------------------

----------------------------WebFrom1.aspx.cs----------------------------------------

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Cache["news"] == null)
{
DataTable dt = LoadData();
//将缓存和外部文件关联，外部文件以改变，缓存立即失效
//Cache.Insert("news", dt, new CacheDependency(@"d:\cache.txt"));

//为缓存设定一个绝对时间，让缓存在这个时间到的时候失效
//Cache.Insert("news", dt, null, DateTime.Now.AddSeconds(20), TimeSpan.Zero);

//为缓存设置一个相对时间，让缓存在这个时间到的时候失效
Cache.Insert("news", dt, null, DateTime.MaxValue, TimeSpan.FromSeconds(30));

//简单的设置一个缓存
Cache.Insert("news", dt);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
else
{
DataTable dt = Cache["news"] as DataTable;
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
}
}
private DataTable LoadData()
{
string strcon = ConfigurationManager.ConnectionStrings["Sqlserver"].ConnectionString;
SqlConnection conn = new SqlConnection(strcon);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "pro_FenYe";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pagesize",500);
cmd.Parameters.AddWithValue("@pageindex",1);
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
cmd.Dispose();
conn.Dispose();
return dt;
}
}

----------------------------web.config----------------------------------

<system.web>
<compilation debug="true" targetFramework="4.0" />
<caching>
<sqlCacheDependency pollTime="500">
<databases>
<add name="sqldependency" connectionStringName="Sqlserver"/>
</databases>
</sqlCacheDependency>
</caching>
</system.web>

在规定时间内访问一个网页时，网页上的内容暂时保持不变，过了特定时间，网页上的内容就会重新访问服务器获取数据。