Major topics covered in this class:
- Contact Management
- Creating a Contacts Table
- Relational Database Concepts
- Displaying Data from Multiple Tables
- Creating a DLOOKUP Function
- Contact Form
- Creating Dynamic Dropdown Lists
In this class we'll deal with Contact
Management, that is, storing different contacts for each of our
customers. Every time I talk to Joe Customer, for example, I want to
track in my database what was said, when we talked, and whether or not I
have to call him back. That's contact management. We'll begin by making
a contact table, and I'll show you how contacts relate to
We'll talk about database concepts such as
Relationships between tables, primary and foreign keys, and so on.
We'll will create a page to list all of the contacts for a specific
Next we'll learn how to create a page that shows
information from multiple tables. For example, we'll display the
specific contact information plus customer data (name) - pulling from
Because pulling information from multiple tables
can involve a lot of code, I'll show you how to create a special
function called DLOOKUP which will let you pull a field from a
table with one line of code. We'll learn about variable scope (local
variables inside a function).
Next, we'll make a contact form where we
can store contact information, add new contacts, and edit existing
contacts. I'll show you how to process the data once it's submitted.
You will next we'll learn how to create a
Dynamic Dropdown List where the data in the list comes from a table.
In this case, you'll fill the list with your customers so you can select
a customer for a specific contact.
Finally, we'll work with text areas and
check boxes and see how ASP deals with those.
You now have enough knowledge under your belt to
begin building some serious web sites with ASP. You know how to
set up a database, read records from it, edit records, add new records,
and delete records. You can work with forms and different types of field
types like text boxes, drop-down boxes, and so on.
Now you're ready to start building a full
e-Commerce web site! That's coming up in the next couple of lessons.