ADO Database ASP.Net


            <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="Default2" %>



    Untitled Page


    
    
                    DataSourceID="SqlDataSource1">
            
                
                
                
                
                
                
                
                
                
            
        
                    runat="server" 
            ConnectionString="<%$ ConnectionStrings:pubsConnectionString2 %>"
            SelectCommand="SELECT * FROM [authors]"
            EnableCaching="True"  
            SqlCacheDependency="CommandNotification">
        
    

    


File: Default.aspx.vb
Partial 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 Class
File: Web.Config


  
  
     providerName="System.Data.SqlClient" />