ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Enabling caching on a SqlDataSource control



    Untitled Page


    
    

                                   Runat="server"
                           SelectCommand="SELECT * FROM [Customers]" 
                           ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"
                           DataSourceMode="DataSet"
                           ConflictDetection="CompareAllValues" 
                           EnableCaching="True" 
                           CacheKeyDependency="SomeKey" 
                           CacheDuration="Infinite">
            
                                    QueryStringField="id" Type="String">
            
        
    

    


File: Web.config

  
  
                     connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"
             providerName="System.Data.SqlClient" />