http://nfex.ru/index.php?action=history&feed=atom&title=ASP.Net%2FADO.net_Database%2FSqlDataSource_Cache 2026-04-29T23:46:30Z История изменений этой страницы в вики MediaWiki 1.30.0 http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/SqlDataSource_Cache&diff=1612&oldid=prev 2010-05-26T15:30:47Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 15:30, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/SqlDataSource_Cache&diff=1613&oldid=prev 2010-05-26T11:50:58Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Enabling caching on a SqlDataSource control==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;csharp&quot;&gt;<br /> &lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot; &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;&gt;<br /> &lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot; &gt;<br /> &lt;head runat=&quot;server&quot;&gt;<br /> &lt;title&gt;Untitled Page&lt;/title&gt;<br /> &lt;/head&gt;<br /> &lt;body&gt;<br /> &lt;form id=&quot;form1&quot; runat=&quot;server&quot;&gt;<br /> &lt;div&gt;<br /> &lt;asp:SqlDataSource ID=&quot;SqlDataSource1&quot; <br /> Runat=&quot;server&quot;<br /> SelectCommand=&quot;SELECT * FROM [Customers]&quot; <br /> ConnectionString=&quot;&lt;%$ ConnectionStrings:AppConnectionString1 %&gt;&quot;<br /> DataSourceMode=&quot;DataSet&quot;<br /> ConflictDetection=&quot;CompareAllValues&quot; <br /> EnableCaching=&quot;True&quot; <br /> CacheKeyDependency=&quot;SomeKey&quot; <br /> CacheDuration=&quot;Infinite&quot;&gt;<br /> &lt;SelectParameters&gt;<br /> &lt;asp:QueryStringParameter Name=&quot;CustomerID&quot; <br /> QueryStringField=&quot;id&quot; Type=&quot;String&quot;&gt;&lt;/asp:QueryStringParameter&gt;<br /> &lt;/SelectParameters&gt;<br /> &lt;/asp:SqlDataSource&gt;<br /> &lt;/div&gt;<br /> &lt;/form&gt;<br /> &lt;/body&gt;<br /> &lt;/html&gt;<br /> File: Web.config<br /> &lt;configuration&gt;<br /> &lt;appSettings/&gt;<br /> &lt;connectionStrings&gt;<br /> &lt;add name=&quot;AppConnectionString1&quot; <br /> connectionString=&quot;Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True&quot;<br /> providerName=&quot;System.Data.SqlClient&quot; /&gt;<br /> &lt;/connectionStrings&gt;<br /> &lt;system.web&gt;<br /> &lt;compilation debug=&quot;true&quot; strict=&quot;false&quot; explicit=&quot;true&quot;&gt;<br /> &lt;codeSubDirectories&gt;<br /> &lt;add directoryName=&quot;VB&quot;&gt;&lt;/add&gt;<br /> &lt;add directoryName=&quot;CS&quot;&gt;&lt;/add&gt;<br /> &lt;/codeSubDirectories&gt;<br /> &lt;/compilation&gt;<br /> &lt;pages&gt;<br /> &lt;namespaces&gt;<br /> &lt;clear/&gt;<br /> &lt;add namespace=&quot;System&quot;/&gt;<br /> &lt;add namespace=&quot;System.Collections&quot;/&gt;<br /> &lt;add namespace=&quot;System.Collections.Specialized&quot;/&gt;<br /> &lt;add namespace=&quot;System.Configuration&quot;/&gt;<br /> &lt;add namespace=&quot;System.Text&quot;/&gt;<br /> &lt;add namespace=&quot;System.Text.RegularExpressions&quot;/&gt;<br /> &lt;add namespace=&quot;System.Web&quot;/&gt;<br /> &lt;add namespace=&quot;System.Web.Caching&quot;/&gt;<br /> &lt;add namespace=&quot;System.Web.SessionState&quot;/&gt;<br /> &lt;add namespace=&quot;System.Web.Security&quot;/&gt;<br /> &lt;add namespace=&quot;System.Web.Profile&quot;/&gt;<br /> &lt;add namespace=&quot;System.Web.UI&quot;/&gt;<br /> &lt;add namespace=&quot;System.Web.UI.WebControls&quot;/&gt;<br /> &lt;add namespace=&quot;System.Web.UI.WebControls.WebParts&quot;/&gt;<br /> &lt;add namespace=&quot;System.Web.UI.HtmlControls&quot;/&gt;<br /> &lt;/namespaces&gt;<br /> &lt;/pages&gt;<br /> &lt;authentication mode=&quot;Windows&quot;&gt;&lt;/authentication&gt;<br /> &lt;identity impersonate=&quot;true&quot;/&gt;<br /> &lt;/system.web&gt;<br /> &lt;/configuration&gt;<br /> &lt;/source&gt;</div>

Admin