Introduction

In this project you will begin making your own set of pages that will integrate with the contacts.mdb database.  You won't be able to do this project without doing prior assignments listed in the schedule.

Starting files for this project are provided for you in your Web account on the cis2.cuyamaca.net server. Just click the "Expand" icon in your files panel to connect to the server and download the contacts & database folders. If you need help, see the last part of the site definition handout.

The contacts.mdb database has the following fields: 

Right now, contacts.mdb contains about 10 records, but you will add records in later projects.  As a matter of fact, you will eventually create forms to add and edit records from a Web page!

For this project, you will create a DSN-less connection to contacts.mdb, create pages and a recordset, and display dynamic data.  View my example before you begin.

Database integration is complex and it can be tricky to troubleshoot problems, so be sure to TEST each step of the way. If you don't test frequently, you will have a difficult time identifying the source of errors.

What to Do

1. You should have downloaded a folder named Contacts from your cis2.cuyamaca.net account.  This folder contains the following files: 
   • add.asp
   • detail.asp
   • list.asp
   • search.asp
   • update.asp
   Create an external CSS that sets the page background color, text color, font face, AND link colors (link, visited, hover, and active).  Attach this style sheet to each file.
   
2. In detail.asp, create a table like this:
   
   

   Name:	(firstName & lastName data will go here)
   Phone Number:	(phone data will go here)
   E-mail Address:	(email data will go here)
   URL:	(link data will go here)

   
   
3. Use the Connection String Handout to create a connection to the contacts.mdb database. Name the connection connContacts. Upload the Connections folder.

   Note:  it's easiest if you copy the connection string (highlighted in yellow) from the handout and paste it into the Custom Connection String dialog box.  Then all you have to do is change the username and the database name.
   

4. Open detail.asp and create a recordset (rsContacts) that includes all the fields (columns) ordered by last name. Test the recordset and upload the contacts folder. 
   
   
5. Add dynamic data to the 2nd column of the table you created in detail.asp.
   
   
6. Add a Recordset Navigation Bar to detail.asp. This appears in the Data Insert menu above the document window.
   
   
   
7. Make the Name a dynamic link by BINDING the link field to the href tag.  To do this:
   1. Select the code for the title dynamic data.
      
      
      
   2. Insert a # in the link box of the properties inspector – this will insert an href tag into the code.
      
      
   3. With the code still highlighted on the page, select the link field in the Data BINDINGS panel and click the Bind button.
      
      
      
      
8. Upload and test your work.  Your file should work like my example. 

Submitting work

• Add a link to this assignment from 213homework.htm.
• Upload your files to the cis2 server. Don't forget to TEST YOUR WORK on the server!
• Submit your URL to Blackboard.

Grading - 60 points