In this demo, I poll the SQL Cache dependency with DataSource caching. I achieve this by first enabling the database for cache dependency. This can be done using the either the aspnet_regsql.exe command line or using the SqlCacheDependencyAdmin class.

SqlCacheDependencyAdmin.EnableNotifications(connectionString);

SqlCacheDependencyAdmin.EnableTableForNotifications(ConfigurationManager.ConnectionStrings["AdminConnectionString"].ConnectionString, strTableName);

I then add a caching element in the web.config to refresh the cache every 60 seconds

<caching>

  <sqlCacheDependency enabled="true" pollTime="60000">

    <databases>

      <add name="WEBSWAPP" connectionStringName ="WEBSWAPPConnectionString" />

  </databases>

  </sqlCacheDependency>

</caching>

Then I set the EnableCaching="true" SqlCacheDependency="WEBSWAPP:Address" on the SqlDataSource object. If you insert a new record in the ListView demo, you have to wait for a minute in order for it to show up on this gridview.

The data structure is explained under the ListView demo. You can view this demo implemented in ASP.NET 2.0 .