Cache ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Cache
  4. Caching with the ObjectDataSource Control
<%@ Page Language="C#" %>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

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



    Show ObjectDataSource Caching


    
    

            id="lblMessage"
        EnableViewState="false"
        Runat="server" />
    
            id="grdProducts"
        DataSourceID="srcProducts"
        Runat="server" />
            id="srcProducts"
        EnableCaching="true"
        CacheDuration="15"
        TypeName="Product"
        SelectMethod="GetProducts"
        OnSelecting="srcProducts_Selecting"
        Runat="server" />
    

    


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;
    }
}