- •Preface
- •Who Should Read This Book
- •Organization and Presentation
- •Contacting the Authors
- •Acknowledgments
- •Contents
- •Introduction
- •Why Microsoft .NET?
- •The Microsoft .NET Architecture
- •Internet Standards
- •The Evolution of ASP
- •The Benefits of ASP.NET
- •What Is .NET?
- •.NET Experiences
- •.NET Clients
- •.NET Services
- •.NET Servers
- •Review
- •Quiz Yourself
- •Installation Requirements
- •Installing ASP.NET and ADO.NET
- •Installing the .NET Framework SDK
- •Testing Your Installation
- •Support for .NET
- •Review
- •Quiz Yourself
- •Designing a Database
- •Normalization of Data
- •Security Considerations
- •Review
- •Quiz Yourself
- •Creating a Database
- •Creating SQL Server Tables
- •Creating a View
- •Creating a Stored Procedure
- •Creating a Trigger
- •Review
- •Quiz Yourself
- •INSERT Statements
- •DELETE Statements
- •UPDATE Statements
- •SELECT Statements
- •Review
- •Quiz Yourself
- •The XML Design Specs
- •The Structure of XML Documents
- •XML Syntax
- •XML and the .NET Framework
- •Review
- •Quiz Yourself
- •ASP.NET Events
- •Page Directives
- •Namespaces
- •Choosing a Language
- •Review
- •Quiz Yourself
- •Introducing HTML Controls
- •Using HTML controls
- •How HTML controls work
- •Intrinsic HTML controls
- •HTML Control Events
- •The Page_OnLoad event
- •Custom event handlers
- •Review
- •Quiz Yourself
- •Intrinsic Controls
- •Using intrinsic controls
- •Handling intrinsic Web control events
- •List Controls
- •Rich Controls
- •Review
- •Quiz Yourself
- •Creating a User Control
- •Adding User Control Properties
- •Writing Custom Control Methods
- •Implementing User Control Events
- •Review
- •Quiz Yourself
- •Common Aspects of Validation Controls
- •Display property
- •Type Property
- •Operator Property
- •Using Validation Controls
- •RequiredFieldValidator
- •RegularExpressionValidator
- •CompareValidator
- •RangeValidator
- •CustomValidator
- •ValidationSummaryx
- •Review
- •Quiz Yourself
- •Maintaining State Out of Process for Scalability
- •No More Cookies but Plenty of Milk!
- •Out of Process State Management
- •Review
- •Quiz Yourself
- •Introducing the Key Security Mechanisms
- •Web.config and Security
- •Special identities
- •Using request types to limit access
- •New Tricks for Forms-based Authentication
- •Using the Passport Authentication Provider
- •Review
- •Quiz Yourself
- •ASP.NET Updates to the ASP Response Model
- •Caching with ASP.NET
- •Page Output Caching
- •Absolute cache expiration
- •Sliding cache expiration
- •Fragment Caching
- •Page Data Caching
- •Expiration
- •File and Key Dependency and Scavenging
- •Review
- •Quiz Yourself
- •A Brief History of Microsoft Data Access
- •Differences between ADO and ADO.NET
- •Transmission formats
- •Connected versus disconnected datasets
- •COM marshaling versus text-based data transmission
- •Variant versus strongly typed data
- •Data schema
- •ADO.NET Managed Provider Versus SQL Managed Provider
- •Review
- •Quiz Yourself
- •Review
- •Quiz Yourself
- •Creating a Connection
- •Opening a Connection
- •Using Transactions
- •Review
- •Quiz Yourself
- •Building a Command
- •Connection property
- •CommandText property
- •CommandType property
- •CommandTimeout property
- •Appending parameters
- •Executing a Command
- •ExecuteNonQuery method
- •Prepare method
- •ExecuteReader method
- •Review
- •Quiz Yourself
- •Introducing DataReaders
- •Using DataReader Properties
- •Item property
- •FieldCount property
- •IsClosed property
- •RecordsAffected property
- •Using DataReader Methods
- •Read method
- •GetValue method
- •Get[Data Type] methods
- •GetOrdinal method
- •GetName method
- •Close method
- •Review
- •Quiz Yourself
- •Constructing a DataAdapter Object
- •SelectCommand property
- •UpdateCommand, DeleteCommand, and InsertCommand properties
- •Fill method
- •Update method
- •Dispose method
- •Using DataSet Objects
- •DataSetName property
- •CaseSensitive property
- •Review
- •Quiz Yourself
- •Constructing a DataSet
- •Tables property
- •TablesCollection Object
- •Count property
- •Item property
- •Contains method
- •CanRemove method
- •Remove method
- •Add method
- •DataTable Objects
- •CaseSensitive property
- •ChildRelations property
- •Columns property
- •Constraints property
- •DataSet property
- •DefaultView property
- •ParentRelations property
- •PrimaryKey property
- •Rows property
- •Dispose method
- •NewRow method
- •Review
- •Quiz Yourself
- •What Is Data Binding?
- •Binding to Arrays and Extended Object Types
- •Binding to Database Data
- •Binding to XML
- •TreeView Control
- •Implement the TreeView server control
- •Review
- •Quiz Yourself
- •DataGrid Control Basics
- •Binding a set of data to a DataGrid control
- •Formatting the output of a DataGrid control
- •Master/Detail Relationships with the DataGrid Control
- •Populating the Master control
- •Filtering the detail listing
- •Review
- •QUIZ YOURSELF
- •Updating Your Data
- •Handling the OnEditCommand Event
- •Handling the OnCancelCommand Event
- •Handling the OnUpdateCommand Event
- •Checking that the user input has been validated
- •Executing the update process
- •Deleting Data with the OnDeleteCommand Event
- •Sorting Columns with the DataGrid Control
- •Review
- •Quiz Yourself
- •What Is Data Shaping?
- •Why Shape Your Data?
- •DataSet Object
- •Shaping Data with the Relations Method
- •Review
- •Quiz Yourself
- •OLEDBError Object Description
- •OLEDBError Object Properties
- •OLEDBError Object Methods
- •OLEDBException Properties
- •Writing Errors to the Event Log
- •Review
- •Quiz Yourself
- •Introducing SOAP
- •Accessing Remote Data with SOAP
- •SOAP Discovery (DISCO)
- •Web Service Description Language (WSDL)
- •Using SOAP with ASP.NET
- •Review
- •Quiz Yourself
- •Developing a Web Service
- •Consuming a Web Service
- •Review
- •Quiz Yourself
- •ASP and ASP.NET Compatibility
- •Scripting language limitations
- •Rendering HTML page elements
- •Using script blocks
- •Syntax differences and language modifications
- •Running ASP Pages under Microsoft.NET
- •Using VB6 Components with ASP.NET
- •Review
- •Quiz Yourself
- •Preparing a Migration Path
- •ADO and ADO.NET Compatibility
- •Running ADO under ASP.NET
- •Early Binding ADO COM Objects in ASP.NET
- •Review
- •Quiz Yourself
- •Answers to Part Reviews
- •Friday Evening Review Answers
- •Saturday Morning Review Answers
- •Saturday Afternoon Review Answers
- •Saturday Evening Review Answers
- •Sunday Morning Review Answers
- •Sunday Afternoon Review Answers
- •What’s on the CD-ROM
- •System Requirements
- •Using the CD with Windows
- •What’s on the CD
- •The Software Directory
- •Troubleshooting
- •ADO.NET Class Descriptions
- •Coding Differences in ASP and ASP.NET
- •Retrieving a Table from a Database
- •Displaying a Table from a Database
- •Variable Declarations
- •Statements
- •Comments
- •Indexed Property Access
- •Using Arrays
- •Initializing Variables
- •If Statements
- •Case Statements
- •For Loops
- •While Loops
- •String Concatenation
- •Error Handling
- •Conversion of Variable Types
- •Index
140 |
Saturday Afternoon |
Fragment Caching
Fragment caching is an approach that caches a portion of a page in memory rather than the entire page as is done when using page output caching. Suppose you have a heavily accessed evaluation or survey form, whose content is static for each user, but whose answers you would like to track based upon a unique userid or value stored or passed in the URL. Using page output caching is not going to provide you much benefit, because it depends upon a unique URL string for caching the output. In our scenario, every request for the page content will generate a unique URL.
Please refer to the FragmentOutputExample.aspx page in the Session 14 folder on the accompanying CD. This example illustrates storing the static survey form in a file called SurveyForm.htm. The first time the page is loaded, SurveyForm.htm is opened and its text is inserted into a cache variable sMyForm. An absolute expiration of 10 seconds is applied to the cached variable, so that all requests occurring 10 seconds after the initial request will load this fragment of the page from cache, rather than loading it from disk.
When you look at the content of the SurveyForm.htm page, you can see that it is a simple survey form that does not change from user to user. Instead, its results need to be uniquely stored based upon the userid information passed in the URL. You can handle this scenario nicely in ASP.NET by caching the fragment of static information in a data cache and retrieving the static data during the generation of the dynamic page (see Listing 14-2).
Listing 14-2 Using fragment caching
<%@ Import Namespace=”System.IO.StringWriter”%> <%@ Import Namespace=”System.IO.File”%>
<%@ Import Namespace=”System.IO”%> <%@ Import Namespace=”System”%> <%@ Page Language=”vb” %>
<HTML>
<HEAD>
<META HTTP-EQUIV=”Content-Type” CONTENT=”text/html; charset=windows-1252”> <SCRIPT LANGUAGE=”VB” RUNAT=”server”>
Sub Page_Load(ByVal Sender As System.Object, ByVal e As System.EventArgs) ‘ Checks to see if the Form is in Memory
Dim bCheckCache as Boolean bCheckCache =CheckCache(“sMyForm”) Select Case bCheckCache
Case True ‘ Set the lblCached to True lblCached.Text = “True”
Case False ‘Set the lblCached to False lblCached.Text =”False”
End Select End Sub
Function CheckCache(sItem as String)
‘Checks for the existince of a Cached Item Dim bCached as Boolean
If Cache.Get(sItem) = Nothing Then bCached = False
Else
bCached = True
Session 14—ASP.NET Caching |
141 |
End If
Return bCached End Function
Function GetCachedForm(sFileName as String, sCacheItem as String) ‘Dim String for Cached HTML Form
Dim sMyForm as String
‘Dim StreamReader to Read HTML From File Dim sr As StreamReader
‘See if Cache Exists
If CheckCache(sCacheItem) Then sMyForm = Cache.Get(sCacheItem)
‘Otherwise if it doesn’t read in survey to cache Else
sr = File.OpenText(server.MapPath(sFileName)) ‘Open File While sr.peek <> -1 ‘Loop Through File
sMyForm = sMyForm & sr.ReadLine() ‘Load Line of Text from File End While
sr.close() ‘ Close FileStream
sr = Nothing ‘Optional Destroy Object Cache.Insert(sCacheItem,sMyForm,Nothing, datetime.Now.AddSeconds(10),
timespan.zero) ‘Insert the HTML Form End If
Return sMyForm End Function
Sub btnSubmit_Click(sender As Object , e As System.Web.UI.WebControls.CommandEventArgs)
‘Insert Code to Write Survey Information to Log File or Database End Sub
</SCRIPT>
</HEAD>
<BODY>
<FORM ID=”FragmentOutputExample” METHOD=”get” ACTION=”FragmentOutputExample.aspx”>
<H2>
Example of Fragment Caching a Form </H2>
<BR>
<%Response.write(GetCachedForm(“SurveyForm.htm”, “sMyForm”))%>
<ASP:BUTTON ID=”btnSubmit” RUNAT=”SERVER” TEXT=”Button” ONCOMMAND=”btnSubmit_Click”></ASP:BUTTON>
<BR>
<P>
</P>
<HR SIZE=”1”> <P>
Was the above form in Cache?
<ASP:LABEL ID=”lblCached” RUNAT=”SERVER”></ASP:LABEL> </P>
<P>
Page Compiled at:<%=datetime.now.tolongtimestring()%> </P>
</FORM>
</BODY>
</HTML>