数据库缓存依赖~ 的列子~ ~

Question

数据库缓存依赖~ 的列子~ ~
主要是后台的操作~  ~ 配置就不用了~
应用程序数据缓存

Answer 1

SqlConnectionconn=newSqlConnection(strConnection);SqlCommandcommand=newSqlCommand(strCommandText,conn);SqlCacheDependencydependency=newSqlCacheDependency(command);dependency.OnChange+=newOnChangeEventHandler(Dependency_OnChange);

Answer 2

http://www.cnblogs.com/luluping/archive/2009/09/13/1565646.html

Answer 3

aspnet_regsql -S "server" -E -d "database" –ed  或者aspnet_regsql -S "server" -E -d "database" -et -t "table"if (HttpRuntime.Cache[""] == null)
                {                    System.Web.Caching.SqlCacheDependency dep = new System.Web.Caching.SqlCacheDependency("", "");
                   HttpRuntime.Cache.Insert("", DateTime.Now.ToString(),
                        dep,
                        System.Web.Caching.Cache.NoAbsoluteExpiration,
                        System.Web.Caching.Cache.NoSlidingExpiration,
                        System.Web.Caching.CacheItemPriority.Default,
                        null);
               
                 }
              else
                {
                    this.GridView1.DataSource = BindData();
                    this.GridView1.DataBind();
               }
            
        }
         private SqlCommand returncommand(string CommandText)
        {
               SqlConnection conn = new SqlConnection("");
               using (SqlCommand cmd = new SqlCommand())
               {
                   conn.Open();
                   cmd.Connection = conn;
                   cmd.CommandType = CommandType.Text;
                   cmd.CommandText = CommandText;
                   return cmd;
               }
         }        private DataSet BindData()
        { 
            SqlCommand cmd=returncommand("");
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            return ds;
         }
 参考

Answer 4

http://www.cnblogs.com/jacksonwj/archive/2009/07/10/1520575.html