/**//// <summary> 
/// 建立缓存依赖项 
/// </summary> 
/// <returns></returns> 
private AggregateCacheDependency TableDependency() 
{ 
AggregateCacheDependency dependency = new AggregateCacheDependency(); 
dependency.Add(new SqlCacheDependency("MSPetShop4", "表名称")); 

return dependency; 
} 

<?xml version="1.0"?> 
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> 
<connectionStrings> 
<add name="LocalConnString" connectionString="Server=(Local);uid=sa;pwd=123456;DataBase=MSPetShop4"/> 
</connectionStrings> 
<system.web> 
<caching> 
<sqlCacheDependency enabled="true" pollTime="10000"> 
<databases> 
<add name="MSPetShop4" connectionStringName="LocalConnString" pollTime="10000"/> 
</databases> 
</sqlCacheDependency> 
</caching> 
<compilation debug="true"/> 
</system.web> 
</configuration> 

aspnet_regsql -S localhost -E -d MSPetShop4 -t Item -et 
aspnet_regsql -S localhost -E -d MSPetShop4 -t Product -et 
aspnet_regsql -S localhost -E -d MSPetShop4 -t Category -et

protected void Page_Load(object sender, EventArgs e) 
{ 
if (!IsPostBack) 
{ 
string key = "TableCache"; //缓存名称 
DataSet data = (DataSet)HttpRuntime.Cache[key]; //获取缓存 

// 判断缓存数据为空 
if (data == null) 
{ 
// 获取数据 
data = GetDataSource(); 

// 创建缓存依赖 
AggregateCacheDependency cd = TableDependency(); 

// 创建缓存 
HttpRuntime.Cache.Add(key, data, cd, DateTime.Now.AddHours(1), Cache.NoSlidingExpiration, 

CacheItemPriority.High, null); 
} 

GridView1.DataSource = data; //绑定数据 
GridView1.DataBind(); 
} 
} 

private DataSet GetDataSource() 
{ 
string ConnectionStringLocal = ConfigurationManager.ConnectionStrings["LocalConnString"].ConnectionString; 
SqlConnection connPubs = new SqlConnection(ConnectionStringLocal); 
SqlDataAdapter dad = new SqlDataAdapter("SELECT TOP 50 * FROM Product", connPubs); 
DataSet ds = new DataSet(); 
dad.Fill(ds); 
return ds; 
}