ASP Scripting Tutorial Video - Try for FREE

Welcome

• Welcome Demo
• Prerequisites for this Course Demo
• About this Course Demo
• Where to Find Documentation Demo

What is ASP?

• Active Server Pages (ASP) Demo
• Extending ASP Demo
• Client Based Scripting - VBScript Demo
• Client Based Scripting - JavaScript Demo
• Server Based Scripting Demo
• Why is Server Based Scripting Necessary? Demo
• Alternatives to ASP Demo
• Pros and Cons of Using ASP Demo

Tools for ASP Development

• What is IIS? (Internet Information Server) Demo
• Installing IIS Demo
• Getting IIS Up and Running Demo
• Getting IIS Up and Running Demo
• Using PWS (Personal Web Server) Demo
• Creating a Simple ASP Scripting Example Demo
• Using Visual Interdev Demo
• Using the Microsoft Script Debugger Demo

Using VBScript

• VBScript in Web Pages
• Procedures and Functions
• The Basics - Datatypes
• The Basics - Variables
• The Basics - Constants
• The Basics - Operators
• The Basics - Other Stuff
• Programming Control Structures
• Objects/Properties and Methods
• A Quick Look at JScript

The Basics of ASP Scripting

• From ASP to HTML
• HTML Tags in ASP
• Referring to Existing HTML Elements
• Header Stuff
• The GLOBAL.ASA File
• Application and Session Objects
• A Hit Counter Page
• The Default Start Page
• Text Files and Concurrency
• Client Persistence and Cookies
• Send and Retrieve
• Including Objects in ASP
• Exclude Business Logic from ASP
• Including Scripts for Reuse pt. 1
• Including Scripts for Reuse pt. 2
• What’s New in ASP3?

Introducing Built In ASP Objects

• What are the Built In ASP Objects?
• The Response Object
• The Request Object
• The Application Object
• The Session Object
• The Server Object
• The Error Object
• The File System
• The Dictionary Object

Simple Built In ASP Objects

• The Application Object pt. 1
• The Application Object pt. 2
• The Application Object pt. 3
• The Application Object pt. 4
• The Error Object
• The Dictionary Object
• The Server Object pt. 1
• The Server Object pt. 2
• The Server Object pt. 3

The Response Object

• The Response Object
• Writing Text to the Client
• Redirecting to a New URL
• Controlling Response with the Buffer
• Ending and Expiring Pages
• Client and Page Status
• Content Type and Character Set
• Obscure Properties and Methods

The Request Object

• The Request Object
• Server Variables
• QueryString URL Parameters
• QueryString Multiple URL Parameters
• QueryString FORM METHOD=GET
• Request.Form
• Obscure Properties and Methods

The Session Object

• What is a Session?
• The Session Object
• Session Start and End Events
• The Contents Collection pt. 1
• The Contents Collection pt. 2
• Connecting and Disconnecting
• Obscure Session Properties

Data Persistence on the Client

• What is Persistence?
• What is a Cookie?
• Cookies in ASP
• Multiple Valued Cookies pt. 1
• Multiple Valued Cookies pt. 2
• Session Cookies
• Are Cookies Enabled on the Client?

Persistence and the File System

• ASP Objects and the File System
• The FileSystem Object
• Using the FileSystem Object pt. 1
• Using the FileSystem Object pt. 2
• The TextStream Object
• Using the TextStream Object
• The Drive Object
• The File Object
• The Folder Object

Database Persistence and ADO

• Database Drivers
• Configuring ODBC and OLEDB
• Reading an Oracle Database
• Reading an Access Database
• What is ADO?
• ADO Object Hierarchy
• ADO Objects Function and Purpose
• ADO Object Attributes pt. 1
• ADO Object Attributes pt. 2

ADO/ASP/ SQL

• The Most Significant ADO Objects
• Recordset Transparent SQL
• What is SQL? The SELECT Statement
• INSERT/UPDATE/DELETE
• SELECT Statement Syntax
• SELECT Statement Syntax WHERE Clause
• SELECT Statement Syntax: GROUP BY
• SELECT Statement Syntax: ORDER BY
• INSERT Statement Syntax
• UPDATE Statement Syntax
• DELETE Statement Syntax
• What is a Transaction?

Retrieving Data From a Database

• What is a Recordset?
• Recordset Fields and Values
• Opening a Recordset
• Closing and Emptying Objects
• Advanced Recordset Options pt. 1
• Advanced Recordset Options pt. 2
• Paging Partial Recordsets
• Disconnected Recordsets pt. 1
• Disconnected Recordsets pt. 2

Changing Data in a Database

• Adding Rows
• The SQL INSERT Statement pt. 1
• The SQL INSERT Statement pt. 2
• Recordset.Addnew pt. 1
• Recordset.Addnew pt. 2
• Changing Rows
• The SQL UPDATE Statement pt. 1
• The SQL UPDATE Statement pt. 2
• Recordset.Update
• Batch Updates pt. 1
• Batch Updates pt. 2
• Batch Updates pt. 3
• Deleting Rows
• The SQL DELETE Statement
• Recordset.Delete

Using Stored Procedures

• Stored Procedures and Functions
• Executing a Stored Procedure
• Using Input Parameters
• Input and Output Parameters
• Input / Output Parameters
• Using Functions

Components

• Instantiating Components
• IIS Resource Kit Components
• E-Mail
• Windows Scripting Components
• Charting
• Where Can Components be Found?

XML in ASP

• What is XML?
• What is XSL?
• The XML Dynamic Object Model in ASP
• Rendering XML Using XSL in ASP
• Generating XML Manually from a Database

Wrapping it Up

• Debugging ASP
• Tuning ASP pt. 1
• Tuning ASP pt. 2
• Security ASP and IIS
• The Future: ASP.NET
• What You Have Learned

Credits

• About the Author