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" ""> <script runat="server">

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

</script> <html xmlns="" > <head id="Head1" runat="server">

   <title>Show ObjectDataSource Caching</title>

</head> <body>

   <form id="form1" runat="server">
       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" />

</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();
       return products;