ASP Course in the San Francisco Bay Area

Using the Response Object

Before a browser receives the HTML of a web page, it accepts various "headers" sent from the server. These headers specify whether the data to be received is an image, an HTML page -- or an instruction to the browser to redirect to another web site or to store a cookie. We will show you how to send these instructions to the browser using the "Response object", which does most of the hard work for you. These headers allow you to store cookies on a browser and redirect the browser to a different web page. You will also learn how to abort processing of an ASP using the Response object.

Subroutines and Functions

Often you will need to perform a sequence of instructions more than once in the same ASP. Subroutines and functions allow you to define your own commands, and then invoke them one or more time on a page. This course will present some examples of subroutines and functions, and show you how to create them.

Session and Application Variables

You can retain information about users between visits to your site using session and application variables. This course will train you in how to create and manipulate these variables and discuss their typical uses. This course will also examine the special global.asa file that contains code that is triggered when the web server starts or new sessions begin.

File Input/Output

Every language has a means of manipulating files on the hard drive, and VBScript is no exception. We will show you the basics of reading and outputting a text files' contents, and also how to write to a file. Using these techniques, you will be able to create a guestbook ASP.

Structured Query Language (SQL) Basics

A separate language is used within ASP to manipulate records in a database. This language is SQL, and is standard among many database programs. Before getting into the ASP integration, we will explain and illustrate the four basic SQL instructions: SELECT, UPDATE, INSERT, and DELETE. This training exercise will give you a chance to try these commands on a sample database using a freeware database client.

Database Integration in ASP

In order to use SQL to retrieve a recordset from a database, or to make deletions/updates/inserts to a table, you need to first create an ASP "connection object". This course will show you how to instantiate these objects in an ASP and the various properties and methods associated with them.

Executing SQL in ASP and Returning Recordsets

After learning some SQL and creating a connection object, you will be ready to create an ASP that inserts, updates, and deletes from our sample database. Going one step further, this course will show you how, using a "recordset" object, you can select records from the database that match certain criteria, and then output them in your ASP.

Prerequisites:

Introductory HTML or equivalent previous experience: must have created and uploaded a web page
Intro ASP or equivalent previous experience: must be familiar with VBScript handling of variables, conditionals, and loops
Basic Knowledge of a relational database (Access, Filemaker, etc.)

keywords: ASP training san francisco bay area (ASP Introduction) ASP classes san francisco bay area (ASP Advanced) ASP .net training course san francisco bay area (ASP 24 Evening Program) ASP training san francisco bay area (ASP .NET Fundamentals)