艾伟_转载：ASP.NET数据缓存之数据缓存浅谈

  ﹤%@ Page Language="C#" AutoEventWireup="true" CodeFile="date.aspx.cs"

 Inherits="date" %﹥  
﹤%@ OutputCache Duration="60" VaryByParam="CustomerID" %﹥  
﹤!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.

org/TR/xhtml1/DTD/xhtml1-transitional.dtd"﹥  

﹤html xmlns="http://www.w3.org/1999/xhtml" ﹥  
﹤head runat="server"﹥  
    ﹤title﹥ASP.NET数据缓存﹤/title﹥  
﹤/head﹥  
﹤body﹥  
    ﹤form id="form1" runat="server"﹥  
    ﹤div﹥  
  ﹤asp:GridView ID="GridView1" runat="server" BackColor="LightGo

ldenrodYellow" 
            BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" 

GridLines="None"﹥  
            ﹤FooterStyle BackColor="Tan" /﹥  
            ﹤SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" /﹥  
            ﹤PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" Horizont

alAlign="Center" /﹥  
            ﹤HeaderStyle BackColor="Tan" Font-Bold="True" /﹥  
            ﹤AlternatingRowStyle BackColor="PaleGoldenrod" /﹥  
        ﹤/asp:GridView﹥  
 ﹤br /﹥  
        ﹤br /﹥  
        ﹤asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/date.aspx?Cu

stomerID=16"﹥16﹤/asp:HyperLink﹥  
        ﹤asp:HyperLink ID="HyperLink2" runat="server" NavigateUrl="~/date.aspx?Cu

stomerID=19"﹥19﹤/asp:HyperLink﹥  
        ﹤/div﹥  
    ﹤/form﹥  
﹤/body﹥  
﹤/html﹥protected void Page_Load(object sender, EventArgs e)  
{  
string conn, comm, id;  
if (Request.QueryString["CustomerID"] == null)  
{  
            id = "16";  
        }  
else 
{   
            id = Request.QueryString["CustomerID"];  
        }  

        conn = "Server=WEB\SQLEXPRESS;Uid=moon;Pwd=1qaz2wsx;Database=store";  
        comm = "SELECT * FROM orders WHERE CustomerID =" + id;  

        SqlDataAdapter da = new SqlDataAdapter(comm, conn);  
        DataSet ds = new DataSet();  
        da.Fill(ds);  

        GridView1.DataSource = ds.Tables[0];  
        GridView1.DataBind();  

        Response.Write(DateTime.Now.ToString());  
    } 

  using System;  
using System.Web.Caching;  
using System.Data;  
using System.Data.SqlClient;  
using System.Configuration;  
using System.Collections;  
using System.Web;  
using System.Web.Security;  
using System.Web.UI;  
using System.Web.UI.WebControls;  
using System.Web.UI.WebControls.WebParts;  
using System.Web.UI.HtmlControls;  

public partial class DataCache : System.Web.UI.Page  
{  
    DataView dv;//先声明一个数据视图用来存放数据库里的数据表  
 
protected void Page_Load(object sender, EventArgs e)  
    {  
        dv = (DataView)Cache["ds"];//从ASP.NET数据缓存中读取数据表  
 
if (dv == null)//如果缓存是空的,就建立数据库连接,从数据库里读数据  
        {  
string conn, comm;  
            conn = "Server=WEB\SQLEXPRESS;Uid=moon;Pwd=1qaz2wsx;Database=store";  
            comm = "SELECT * FROM orders";  

            SqlDataAdapter da = new SqlDataAdapter(comm, conn);  
            DataSet ds = new DataSet();  
            da.Fill(ds);  
            dv = ds.Tables[0].DefaultView;  
//下面这句是关键,具体参数后面介绍  
            Cache.Insert("ds", dv, null, System.Web.Caching.Cache.NoAbsoluteExpiration, 

TimeSpan.FromMinutes(3));  
            Databind();  
            Label1.Text = DateTime.Now.ToString();//参考用的时间,可有可无  
        }  
else 
        {  
            Databind();  
            Response.Write("Is Cache Data!!!");//此句可有可无  
        }  
    }    

protected void Databind()//自定义的数据绑定方法  
    {  
        GridView1.DataSource = dv;  
        GridView1.DataBind();  
    }  
}