http://nfex.ru/index.php?action=history&feed=atom&title=ASP.NET_Tutorial%2FCache%2FSqlDataSource_cache
ASP.NET Tutorial/Cache/SqlDataSource cache - История изменений
2026-04-29T20:51:18Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://nfex.ru/index.php?title=ASP.NET_Tutorial/Cache/SqlDataSource_cache&diff=2885&oldid=prev
в 15:30, 26 мая 2010
2010-05-26T15:30:57Z
<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_Tutorial/Cache/SqlDataSource_cache&diff=2886&oldid=prev
Admin: 1 версия
2010-05-26T11:57:22Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Adding Items with an Absolute Expiration Policy==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" Trace="true" %><br />
<%@ Import Namespace="System.Data" %><br />
<%@ Import Namespace="System.Data.SqlClient" %><br />
<%@ Import Namespace="System.Web.Configuration" %><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"<br />
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br />
<script runat="server"> void Page_Load()<br />
{<br />
DataTable products = (DataTable)Cache["Products"];<br />
if (products == null)<br />
{<br />
products = GetProductsFromDB();<br />
Cache.Insert("Products", products, null, DateTime.Now.AddHours(1), Cache.NoSlidingExpiration);<br />
}<br />
grdProducts.DataSource = products;<br />
grdProducts.DataBind();<br />
}<br />
private DataTable GetProductsFromDB()<br />
{<br />
Trace.Warn("Getting products from database");<br />
string conString = WebConfigurationManager.ConnectionStrings ["Products"].ConnectionString;<br />
SqlDataAdapter dad = new SqlDataAdapter("SELECT Title,Director FROM Products", conString);<br />
DataTable products = new DataTable();<br />
dad.Fill(products);<br />
return products;<br />
}<br />
</script><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head id="Head1" runat="server"><br />
<title>Show Absolute Expiration</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:GridView<br />
id="grdProducts"<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html></source><br />
<br />
<br />
<br />
== Adding Items with a Sliding Expiration Policy==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" Trace="true" %><br />
<%@ Import Namespace="System.Data" %><br />
<%@ Import Namespace="System.Data.SqlClient" %><br />
<%@ Import Namespace="System.Web.Configuration" %><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"<br />
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br />
<script runat="server"><br />
void Page_Load()<br />
{<br />
DataSet products = (DataSet)Cache["Products"];<br />
if (products == null)<br />
{<br />
products = GetProductsFromDB();<br />
Cache.Insert("Products", products, null, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(5));<br />
}<br />
grdProducts.DataSource = products;<br />
grdProducts.DataBind();<br />
}<br />
private DataSet GetProductsFromDB()<br />
{<br />
Trace.Warn("Getting products from database");<br />
string conString = WebConfigurationManager.ConnectionStrings ["Products"].ConnectionString;<br />
SqlDataAdapter dad = new SqlDataAdapter("SELECT Title,Director FROM Products", conString);<br />
DataSet products = new DataSet();<br />
dad.Fill(products);<br />
return products;<br />
}<br />
</script><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head id="Head1" runat="server"><br />
<title>Show Sliding Expiration</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:GridView<br />
id="grdProducts"<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html></source><br />
<br />
<br />
<br />
== Adding Items with Dependencies==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#" Trace="true" %><br />
<%@ Import Namespace="System.Data" %><br />
<%@ Import Namespace="System.Data.SqlClient" %><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"<br />
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br />
<script runat="server"><br />
void Page_Load()<br />
{<br />
DataSet products = (DataSet)Cache["Products"];<br />
if (products == null)<br />
{<br />
Trace.Warn("Retrieving products from file system");<br />
products = new DataSet();<br />
products.ReadXml(MapPath("~/Data.xml"));<br />
CacheDependency fileDepend = new CacheDependency(MapPath("~/Data.xml"));<br />
Cache.Insert("Products", products, fileDepend);<br />
}<br />
grdProducts.DataSource = products;<br />
grdProducts.DataBind();<br />
}<br />
</script><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head id="Head1" runat="server"><br />
<title>Show File Dependency</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:GridView<br />
id="grdProducts"<br />
Runat="server" /><br />
</div><br />
</form><br />
</body><br />
</html></source><br />
<br />
<br />
<br />
== SqlDataSource caching==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="csharp"><br />
<%@ Page Language="C#"%><br />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml" ><br />
<head runat="server"><br />
<title>Untitled Page</title><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<asp:SqlDataSource ID="sourceEmployeeCities" <br />
runat="server" <br />
ProviderName="System.Data.SqlClient" <br />
ConnectionString="<%$ ConnectionStrings:Northwind %>" <br />
SelectCommand="SELECT DISTINCT City FROM Employees"<br />
EnableCaching="True" <br />
CacheDuration="3600"><br />
</asp:SqlDataSource><br />
<asp:DropDownList ID="lstCities" <br />
runat="server" <br />
DataSourceID="sourceEmployeeCities"<br />
DataTextField="City" <br />
Width="205px" <br />
AutoPostBack="True"><br />
</asp:DropDownList><br />
<br />
<asp:SqlDataSource ID="sourceEmployees" <br />
runat="server" <br />
ProviderName="System.Data.SqlClient" <br />
ConnectionString="<%$ ConnectionStrings:Northwind %>" <br />
SelectCommand="SELECT EmployeeID, FirstName, LastName, Title, City FROM Employees WHERE City=@City"<br />
EnableCaching="True" <br />
CacheDuration="600"><br />
<SelectParameters><br />
<asp:ControlParameter ControlID="lstCities" Name="City" PropertyName="SelectedValue" /><br />
</SelectParameters><br />
</asp:SqlDataSource><br />
<asp:GridView ID="GridView1" <br />
runat="server" <br />
DataSourceID="sourceEmployees" <br />
AutoGenerateColumns="False" <br />
DataKeyNames="EmployeeID"><br />
<AlternatingRowStyle BackColor="White" /><br />
<Columns><br />
<asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" InsertVisible="False"<br />
ReadOnly="True" SortExpression="EmployeeID" /><br />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" /><br />
<asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" /><br />
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" /><br />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" /><br />
</Columns><br />
</asp:GridView><br />
<br />
</div><br />
</form><br />
</body><br />
</html><br />
File: Web.config<br />
<?xml version="1.0"?><br />
<configuration><br />
<connectionStrings><br />
<add name="Northwind" connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI"/><br />
</connectionStrings><br />
</configuration></source></div>
Admin