Major topics covered in this class:
- User Logon
- Securing Your Site
- Create a Search Form
- Dropdown Boxes
- Menubar & Header for Your Site
We will begin this class by discussing web site
security. What do you need to do on your ASP pages to prevent
authorized use? We will add a User table to our database, and set
up user accounts.
You will learn how to set up each sensitive page
(such as a page on which data can be altered) so that someone needs to
be logged in to access it. We'll track that information in
Next, we will create a search form, so that
your users can query your database. They will be able to search by First
Name, Last Name, Customer Since, etc. You will learn how to perform a
Wildcard search using SQL statements.
Your search results will be displayed in a
table similar to our customer list, showing all of the returned records:
You will next learn how ASP handles dropdown
boxes with static options. We'll pick a state from a list of states
and you'll see how to store that information in the table. We'll learn
the difference between the stored value and the displayed value -
so that we can store "PA" but show "Pennsylvania" in the box, for
Finally, we'll create a proper site header
for our web, complete with navigation hyperlinks and user logon
I'll also show you how to display "one-time"
system messages to your users when specific events happen.
We're getting closer to being able to design a
full web site with ASP. Now we know how to secure our pages, create
a search form, a navigation bar, and handle dropdown boxes.