Web Development - William M. Pegram

ASP Schedule

This schedule will be revised throughout the course. Chapter references are to Beginning Active Server Pages 3.0

Student Pages:

Session	Topics	Exercises
1	Getting Started with ASP, working with IIS (Ch. 1)
2	Server-Side Scripting and Client-Side Scripting (Ch. 2)
3	Basic ASP Techniques (Ch. 3)
4	Variables (Ch. 4)
5	ASP Control Structures (Ch. 5)
6	Objects, Properties, Methods, Events (Ch. 6) Why Use Server-Side Scripting? FTP Using Browser (FTP Instructions) Server Behavior when page request doesn't include filename
7	Request and Response Objects (Ch. 7) FTP Using FTP Client CoreFTP	Questions on Chapters 1-5 Table, Form, and ASP Exercise
8	Applications, Sessions, and Cookies (Ch. 8) - example of global.asa file Inclass development of Login pages using Session Variables - Login form, Login Action (code), Page to be protected (try it, code), File included in pages to be protected (code), Code from all 4 pages
9	Error Handling (Ch. 9) Scripting Objects (Ch. 10) - Dictionary Object, FileSystemObject - displaying a file directory with links to files (code), displaying ASP code of a file (code)
10	Scripting Objects (cont.) - Text Stream Object ASP Components (Ch. 11) - Ad Rotator Component - display page (code), scheduler txt file, redirector file (code), display clickthrough count (code) Recoding of Login Page to provide for return to page initially sought - file included in pages to be protected (code), login action (code)
11	ASP Components (cont.) - Content Linking/NextLink and Browser Capabilities Components Displaying List of Microsoft ASP Components and their Methods/Properties through VBA Editor in Word, Excel, or Access
12	Database Concepts (table, records, fields, primary key, foreign key, relational database, referential integrity, normalization) Creating Tables in Microsoft Access ASP and Data Store Access (Ch. 12) - connection via connection string (code), connection via data link file (code, code of datalink file), connection (data link file generates connection string which is then pasted (code), connection via system data source name (code), connection via connection string using Server.MapPath (code) Using Recordsets (Ch. 13) - ADO Constants, Cursor Types, Locking, Recordset EOF & BOF Properties, MoveNext and related Methods
13	Using Recordsets (cont.) - Bookmarks, Find method, Filter Property, Fields collections, GetRows Advanced Data Handling Techniques (Ch. 14) - Putting database connection (code) and database close (code) into include files, SELECT SQL and Command Object Execute method, accessing ADO constants through metadata statement and SSI, SELECT statement with related tables, SELECT statement with related tables and criteria to select records, UPDATE statement
14	Insert and Delete SQL statements, using input from forms (dynamic SQL) - form, form with output in table, form with output in tables, with HTML and ASP intermixed and passing primary key in link to delete action page (code) (Ch. 14)
15	Using Recordsets to insert, update, and delete records rather than SQL statements (Ch. 14) Put query in Access rather than ASP Using ASP to dynamically populate form from database, using ASP to pass parameter to Access parameter query Function to write out table (code) Debugging on Projects
16	Writing an Application (Ch. 15)	Project (tentative)
17	Building Script Components for ASP (Ch. 16)
18	Introducing Transactions and COM+ (Ch. 17)
19	An Introduction to XML (Ch. 18)

Revised: January 8, 2007. Comments to William Pegram, bill@billpegram.com