sqlcachedependency( sqlcommand) sqlcachedependency(string database,string tablename) 我建立的缓存:数据库:netmeeting 表:employee 、 department 建立方法:数据库缓存的配置 前台代码: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="mySqlCacheDependency.aspx.cs" Inherits="mySqlCacheDependency" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body style="height: 377px"> <form id="form1" runat="server"> <div style="height: 376px"> <div style="text-align: center; float: left; height: 151px; width: 618px;"> <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label> </div> <div style="text-align: center; float: left;height: 151px; width: 621px;"> <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" /> </div> </div> </form> </body> </html> 后台代码: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class mySqlCacheDependency : System.Web.UI.Page { protected void ShowTime() { string key = "time"; string timeStr = (string)HttpRuntime.Cache[key]; if (string.IsNullOrEmpty(timeStr)) { //the first time or sql has changed timeStr = DateTime.Now.ToString(); Cache.Insert(key,timeStr,CacheDependencyFactory.Facade.GetDependency()); } //show time Label1.Text = timeStr; } protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) ShowTime(); } protected void Button1_Click(object sender, EventArgs e) { ShowTime(); } } 其他文件,…………示例下载: 路径lover's-->MyProgram-->netmeeting-->缓存