ASP.NET Tutorial/Cache/ObjectDataSource cache

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

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>

Источник — «http://www.nfex.ru/index.php?title=ASP.NET_Tutorial/Cache/ObjectDataSource_cache&oldid=2890»