|
|
|
wl620-ver3.3
Advanced Microsoft Active Server Pages (2 days)
Description
This courseware training guide book will teach sophisticated programming strategies and advanced features to add polish, speed and efficiency to your Active Server Pages Web applications. This advanced class builds on our Introduction to Active Server Pages courses to provide an in-depth look at ASP. In this course, you will work more thoroughly with ASP components for Web-to-database integration and use the server's file system to add features and functionality to your Web site. In addition, you will work with other components, including those that ship with ASP as well as those you can purchase from 3rd party vendors.
Suggested PrerequisitesIntroduction to Microsoft Active Server Pages for New Programmers
Next CourseIntegrating ASP and XML
ObjectivesBy the end of the class students will be able to:
• Implement advanced drill-downs
• Debug ASP code
• Work with stored procedures
• Use batch updating
• Work with 3rd-party vendor components
• Access the file system of the server
Course OutlineIntroduction • The Database Used for the Class • The Laundry Detergent Company Site • File Naming Convention
File Conventions • Connection Pooling • Dynamic Connection Strings • Default METHOD and ACTION values
Advanced Data Drill-Downs • An Example of Passing Data via the QueryString • Example: Drilling Down with Database Data • Using Drill-Downs to Reformat Data • Exercise 1: Displaying the Clients in a Column-Sortable Table
Displaying Variables • Example: drillvariables.asp • Exercise 2: Displaying Variables in the Column-Sortable Table • variableshow.inc
Multi-Table Queries • Example: Orders Listed by Client Name
Displaying a Portion of the Recordset • Example: Displaying the next 5, 10, or 15 records: • A Note About Process • Exercise 3: Displaying the next X records in the Database
Password Protection with Session Variables • Example: Pages with Password Protection • Exercise 4: Adding Password Protection To Your Pages
Using Stored Procedures • Creating a Stored Procedure in the Database • Advantages of Stored Procedures • Exercise 5: Using Stored Procedures
Using Stored Procedures to Insert and Update • Example: the update_client Stored Procedure • Exercise 6: Using a Stored Procedure to Enter Clients into the Database
Working with the File System in ASP • The FileSystemObject • Creating or Opening a Text File • Methods of the TextStream Object • An Example: Building a Personal HTML Page • Exercise 7: Storing Text to a File • The File Object • The Folder Object • Exercise 8: Working with Files and Directories
Processing File Uploads • Obtaining a Component for Processing File Uploads • The AspUpload Component • Building an HTML Form that Supports File Uploads • Processing the File on the Server with AspUpload • Processing Files and Entered Text • SetMaxSize • Manipulating Files via AspUpload • Creating a New Directory • Restricting Your Upload to Certain File Extensions • Exercise 9: Building a Resume Submission Interface
Batch Updating • Opening the Recordset for Batch Updating • Editing the Records Row by Row • Updating the Batch • So Why Use Batches• • A Few VBScript Functions • Exercise 10: Implementing Batch Updating
Using rs.Update Instead of INSERT • What's Happening Here•
Form Validation with Server-Side JScript and Regular Expressions • Server-Side Form Validation with JScript • Exercise 11: Completing a Client-Side/Server-Side Form Validation Application
Transactions in ASP • Handling Errors • Exercise 12: Catching Database Errors via Transactions
Creating Message Boards • Part 1: Creating HTML Files • Creating the Database • The Interface
Exercise 13: Building a Moderated Message Board
A Brief Examination of clientdetails.asp • Regular Expressions • Creating and Executing a Regular Expression with exec() • Special Characters for Pattern Matching • Escape Sequences for Special Characters • Specifying Ranges in Patterns • Matching a Specified Number of Occurrences • Character-Range Escape Sequences • Matching at the Beginning or End of a String with ^ and $ • The Word-Boundary Pattern Anchors: \b and \B • Ignoring Case with the iModifier • Common VBScript Functions
|
|
|
|
|
