Assignment 10 - Integrating a Database with ASP Pages

Create a database application in a Web page of your choice. For example, you could set up a membership database for a club, an employee database, or even an e-commerce product database with a shopping cart.

Your application should include each of the following:

• a form for users to enter their information
• another form for users to update and make changes to their information (password protected)
• an administrator's Web page where administrators can view, edit, search and delete records

All the data should be stored in an Access database in your A## account on the class Web server.

Your user form must include each of the following form field types:

• at least one text box
• at least two groups of radio buttons
• at least two groups of check boxes
• at least one drop down list

HINT: Copy and paste THIS code into your asp page that your form posts to (action=), before you start writing code to add information to your database. This will help avoid errors relating to field names. You can see exactly what is sent to your response page - especially helpful with radio buttons, check boxes and drop down lists (form elements that may require special code).

See Common ASP Errors page for common problems you may encounter. Download Grade Sheet.