Cache ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Cache
  4. Using Polling SQL Cache Dependencies with Data Caching
<%@ Page Language="C#" Trace="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web.Configuration" %>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    void Page_Load()
    {
        DataTable products = (DataTable)Cache["Products"];
        if (products == null)
        {
            products = GetProductsFromDB();
            SqlCacheDependency sqlDepend = new SqlCacheDependency("MyDatabase", "Products");
            Cache.Insert("Products", products, sqlDepend);
        }
        grdProducts.DataSource = products;
        grdProducts.DataBind();
    }
    private DataTable GetProductsFromDB()
    {
        Trace.Warn("Retrieving data from database");
        string conString = WebConfigurationManager.ConnectionStrings ["Products"].ConnectionString;
        SqlDataAdapter dad = new SqlDataAdapter("SELECT Title,Director FROM Products", conString);
        DataTable products = new DataTable();
        dad.Fill(products);
        return products;
    }



    Polling SQL Data Cache


    
    

            id="grdProducts"
        Runat="server" />