ASP.Net/ADO.net Database/SqlDataSource Cache

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

Enabling caching on a SqlDataSource control

   <source lang="csharp">

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> 

   <title>Untitled Page</title>

</head> <body> 

   <form id="form1" runat="server">

       <asp:SqlDataSource ID="SqlDataSource1" 
                          Runat="server"
                          SelectCommand="SELECT * FROM [Customers]" 
                          ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"
                          DataSourceMode="DataSet"
                          ConflictDetection="CompareAllValues" 
                          EnableCaching="True" 
                          CacheKeyDependency="SomeKey" 
                          CacheDuration="Infinite">
           <SelectParameters>
               <asp:QueryStringParameter Name="CustomerID" 
                   QueryStringField="id" Type="String"></asp:QueryStringParameter>
           </SelectParameters>
       </asp:SqlDataSource>

   </form>

</body> </html> File: Web.config <configuration> 

 <appSettings/>
 <connectionStrings>
       <add name="AppConnectionString1" 
            connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"
            providerName="System.Data.SqlClient" />
   </connectionStrings>
 <system.web>
   <compilation debug="true" strict="false" explicit="true">
     <codeSubDirectories>
       <add directoryName="VB"></add>
       <add directoryName="CS"></add>
     </codeSubDirectories>
   </compilation>
   <pages>
     <namespaces>
       <clear/>
       <add namespace="System"/>
       <add namespace="System.Collections"/>
       <add namespace="System.Collections.Specialized"/>
       <add namespace="System.Configuration"/>
       <add namespace="System.Text"/>
       <add namespace="System.Text.RegularExpressions"/>
       <add namespace="System.Web"/>
       <add namespace="System.Web.Caching"/>
       <add namespace="System.Web.SessionState"/>
       <add namespace="System.Web.Security"/>
       <add namespace="System.Web.Profile"/>
       <add namespace="System.Web.UI"/>
       <add namespace="System.Web.UI.WebControls"/>
       <add namespace="System.Web.UI.WebControls.WebParts"/>
       <add namespace="System.Web.UI.HtmlControls"/>
     </namespaces>
   </pages>
   <authentication mode="Windows"></authentication>
   <identity impersonate="true"/>
 </system.web>

</configuration> 

</source>
Источник — «http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/SqlDataSource_Cache&oldid=1613»