ASP.NET Tutorial/Cache/ObjectDataSource cache

Материал из .Net Framework эксперт
Версия от 14:57, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

Caching with the ObjectDataSource Control

   <source lang="csharp">

<%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server">

   protected void srcProducts_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
   {
       lblMessage.Text = "Selecting data from component";
   }

</script> <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server">

   <title>Show ObjectDataSource Caching</title>

</head> <body>

   <form id="form1" runat="server">
   <asp:Label
       id="lblMessage"
       EnableViewState="false"
       Runat="server" />
   

<asp:GridView id="grdProducts" DataSourceID="srcProducts" Runat="server" /> <asp:ObjectDataSource id="srcProducts" EnableCaching="true" CacheDuration="15" TypeName="Product" SelectMethod="GetProducts" OnSelecting="srcProducts_Selecting" Runat="server" />
   </form>

</body> </html> File: Product.cs using System; using System.Data; using System.Data.SqlClient; using System.Web.Configuration; public class Product {

   public static DataTable GetProducts()
   {
       string conString = WebConfigurationManager.ConnectionStrings["Products"]. ConnectionString;
       SqlDataAdapter dad = new SqlDataAdapter("SELECT Title,Director FROM Products", conString);
       DataTable products = new DataTable();
       dad.Fill(products);
       return products;
   }

}</source>