CSharp Set Sqlcachedependency – ADO.Net Database

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="Default2" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="au_id"
            DataSourceID="SqlDataSource1">
            <columns>
                <asp:BoundField DataField="au_id" HeaderText="au_id" ReadOnly="True" SortExpression="au_id" />
                <asp:BoundField DataField="au_lname" HeaderText="au_lname" SortExpression="au_lname" />
                <asp:BoundField DataField="au_fname" HeaderText="au_fname" SortExpression="au_fname" />
                <asp:BoundField DataField="phone" HeaderText="phone" SortExpression="phone" />
                <asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
                <asp:BoundField DataField="city" HeaderText="city" SortExpression="city" />
                <asp:BoundField DataField="state" HeaderText="state" SortExpression="state" />
                <asp:BoundField DataField="zip" HeaderText="zip" SortExpression="zip" />
                <asp:CheckBoxField DataField="contract" HeaderText="contract" SortExpression="contract" />
            </columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1"
            runat="server"
            ConnectionString="<%$ ConnectionStrings:pubsConnectionString2 %>"
            SelectCommand="SELECT * FROM [authors]"
            EnableCaching="True"
            SqlCacheDependency="CommandNotification">
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>File: Default.aspx.vbPartial Class Default2
    Inherits System.Web.UI.Page    Protected Sub Page_Load(ByVal sender As Object, _
       ByVal e As System.EventArgs) Handles Me.Load
        Dim settings As ConnectionStringSettings
        settings = _
           ConfigurationManager.ConnectionStrings("PubsDatabase")
        System.Data.SqlClient.SqlDependency.Start( _
           settings.ConnectionString)
    End Sub
End ClassFile: Web.Config<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
  <appSettings/>
  <connectionStrings>
  <add name="PubsDatabase" connectionString="Server=.\SQLEXPRESS;Integrated Security=True;Database=pubs;Persist Security Info=True"
   providerName="System.Data.SqlClient" />
 </connectionStrings>
  <system.web>
    <compilation debug="true"/>
    <authentication mode="Windows"/>
    <caching>
      <sqlCacheDependency enabled="true">
        <databases>
          <add name="Pubs" connectionStringName="PubsDatabase" pollTime="10000"/>
        </databases>
      </sqlCacheDependency>
    </caching>
  </system.web>
</configuration>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.