How To Cache in ASP.NET by Using Visual Basic .NET (811431)

MORE INFORMATION

ASP.NET provides convenient methods to control caching. You can use the @ OutputCache directive to control page output caching in ASP.NET. Use HttpCachePolicy class to store arbitrary objects, such as datasets, to the server memory. You can store the cache in applications such as the client browser, the proxy server, and Microsoft Internet Information Services (IIS). By using Cache-Control HTTP Header, you can control caching.

For additional information about ASP.NET output caching, click the following article number to view the article in the Microsoft Knowledge Base: back to the top

Cache ASP.NET Pages

You can cache by using the @ OutputCache directive, or programmatically through code by using Visual Basic .NET or Visual C# .NET. The @ OutputCache directive contains a Location attribute. This attribute determines the location for the cached item. You may specify one of the following locations:

• Any - This stores the output cache in the client's browser, on the proxy server (or any other server) that participates in the request, or on the server where the request is processed. By default, Any is selected.
• Client - This stores output cache on the client's browser.
• Downstream - This stores the output cache in any cache-capable devices (other than the origin server) that participate in the request.
• Server - This stores the output cache on the Web server.
• None - This turns off the output cache.

The following are code samples for the @ OutputCache directive and equivalent programmatic code.

• To store the output cache for a specified duration
  
  Declarative Approach:
  

  <%@ OutputCache Duration="60" VaryByParam="None" %>

  
  Programmatic Approach:
  

  Response.Cache.SetExpires(DateTime.Now.AddSeconds(60))
  Response.Cache.SetCacheability(HttpCacheability.Public)

• To store the output cache on the browser client where the request originated
  
  Declarative Approach:
  

  <%@ OutputCache Duration="60" Location="Client" VaryByParam="None" %>

  
  Programmatic Approach:
  

  Response.Cache.SetExpires(DateTime.Now.AddSeconds(60))
  Response.Cache.SetCacheability(HttpCacheability.Private)
  

• To store the output cache on any HTTP 1.1 cache-capable devices including the proxy servers and the client that made request
  
  Declarative Approach:
  

  <%@ OutputCache Duration="60" Location="Downstream" VaryByParam="None" %>

  
  Programmatic Approach:
  

  Response.Cache.SetExpires(DateTime.Now.AddSeconds(60))
  Response.Cache.SetCacheability(HttpCacheability.Public)
  Response.Cache.SetNoServerCaching()

• To store the output cache on the Web server
  
  Declarative Approach:
  

  <%@ OutputCache Duration="60" Location="Server" VaryByParam="None" %>

  
  Programmatic Approach:
  

  Response.Cache.SetExpires(DateTime.Now.AddSeconds(60))
  Response.Cache.SetCacheability(HttpCacheability.Server)
  

• To cache the output for each HTTP request that arrives with a different City
  
  Declarative Approach:
  

  <%@ OutputCache duration="60" varybyparam="City" %>
  

  
  Programmatic Approach:
  

  Response.Cache.SetExpires(DateTime.Now.AddSeconds(60))
  Response.Cache.SetCacheability(HttpCacheability.Public)
  Response.Cache.VaryByParams("City") = true
  

  For the VaryByCustom attribute, the VaryByHeader attribute, and the VaryByParam attribute in the @ OutputCache directive, the HttpCachePolicy class provides the VaryByHeaders property and the VaryByParams property, and the SetVaryByCustom method.

back to the top

Turn Off Client and Proxy Caching

To turn off the output cache for an ASP.NET Web page at the client location and at the proxy location, set the Location attribute value to none, and then set the VaryByParam value to none in the @ OutputCache directive. Use the following code samples to turn off client and proxy caching.

• Declarative Approach:

  <%@ OutputCache Location="None" VaryByParam="None" %>

• Programmatic Approach:

  Response.Cache.SetCacheability(HttpCacheability.NoCache)

back to the top

Cache Arbitrary Objects in Server Memory

ASP.NET includes a powerful, easy-to-use caching mechanism that you can use to store objects that require a lot of server resources to create in memory. The Cache class implements this method. Instances are private to each application and the lifetime is tied to the corresponding application. To cache the arbitrary objects in ASP.Net by using the Cache class, follow these steps:

1. Create a new ASP.NET Web Application by using Visual Basic .NET.
2. By default, WebForm1.aspx is created.
3. In the HTML view of WebForm1.aspx, replace the existing code with the following sample code:

   <%@ Import Namespace="System.Data.SqlClient" %>
   <%@ Import Namespace="System.Data" %>
   <HTML>
   	<script language="vb" runat="server">
   
   		Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
   			Dim Source As DataView
   
   		'Retrieve the DataView object from the Cache class. If it does not exist, add the DataView object to the Cache class.
   
   		Source = CType(Cache("MyDataSet"), DataView)
   
   		If Source Is Nothing Then
   
   			Dim myConnection As SqlConnection = New SqlConnection("Server=ServerName; database=Pubs; user id=UID; password=PWD;")
   			Dim myCommand As SqlDataAdapter = New SqlDataAdapter("select * from Authors", myConnection)
   			Dim ds As DataSet = New DataSet()
   			myCommand.Fill(ds, "Authors")
   
   			Source = New DataView(ds.Tables("Authors"))
   			Cache("MyDataSet") = Source
   			CacheMsg.Text = "Dataset created explicitly"
   			
   		Else
   			
   			CacheMsg.Text = "Dataset retrieved from cache"
   
   		End If
   
   		' Bind the DataView object to DataGrid. 
   		MyDataGrid.DataSource = Source
   		MyDataGrid.DataBind()
   
   		End Sub
   
   	</script>
   	<body>
   		<form method="GET" runat="server" ID="Form1">
   	      <h3><font face="Verdana">Caching Data</font></h3>
   			<ASP:DataGrid id="MyDataGrid" runat="server"
   			Width="700"
   			BackColor="#ccccff"
   			BorderColor="black"
   			ShowFooter="false"
   			CellPadding=3
   			CellSpacing="0"
   			Font-Name="Verdana"
   			Font-Size="8pt"
   			HeaderStyle-BackColor="#aaaad" />
   			<p>
   			<i><asp:label id="CacheMsg" runat="server"/></i>
   	    </form>
   		</P>
   	</body>
   </HTML>

   Note Replace the values for ServerName, UID, and PWD in the sample code for the SqlConnection object with your SQL Server Name, User ID, and Password.
4. On the Debug menu, click Start to run the application.
   
   Note When you restart the application, the Cached object is re-created.

back to the top