Thomas Wallace: Lectures and Resources - A collection of website design lectures and resources

Planning your Web site/Database Interaction

Before we begin working with .asp pages and a database we need to establish what all needs to occur in order for our site to function as we would like. For this example we will create a small web application that allows us to collect names and email addresses that we will store in a database. We will need to create an interface that allows a user to submit this information from a web form and a page that we can use to see the data in the database.

What We Need

1. A simple Access Database
2. A connection between the database and our web site
3. A Recordset (Query) that requests the appropriate fields in the database
4. A page that allows us to insert data into our database
5. A page that allows us to view data inside of our database
6. A page that the user will be directed to after they have submitted the form.