Cache ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Cache
  4. Using Polling SQL Cache Dependencies with DataSource Caching
<%@ Page Language="C#" %>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    protected void srcProducts_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        lblMessage.Text = "Retrieving data from database";
    }



    Polling SQL DataSource Cache


    
    

            id="lblMessage"
        EnableViewState="false"
        Runat="server" />
    
            id="grdProducts"
        DataSourceID="srcProducts"
        Runat="server" />
            id="srcProducts"
        ConnectionString="<%$ ConnectionStrings:Products %>"
        SelectCommand="SELECT Title, Director FROM Products"
        EnableCaching="true"
        SqlCacheDependency="MyDatabase:Products"
        OnSelecting="srcProducts_Selecting"
        Runat="server" />