|
||||||||||||||||||||||
|
||||||||||||||||||||||
|
Major topics covered in this class:
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 Session variables.
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 example.
Finally, we'll create a proper site header for our web, complete with navigation hyperlinks and user logon information.
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. |
||||||||||||||||||||||
|
|
||||||||||||||||||||||
|
||||||||||||||||||||||
| ||||||||||||||||||||||
|
| ||||||||||||||||||||||
|
| ||||||||||||||||||||||
|
