ITP 250 Week 6
Lab 4 – Application Functionality
During the last lab, you created a database in SQL Server. Inside this database you created a table that stores Membership/Sign-up information for your end-users/customers. The database table was populated from an .asp page. After a user signs up, he/she typically will logon and begin to use the application. In order to validate the logon, you must write code that will search the database table (containing username/password information) through creating a recordset and check to see if there is a match for the username and password. If you come to the end of the recordset, then the username or password was not found/correct. If there is a successful match, the user enters your web-based application.
For this lab, you will design functionality that enables the user to use your application. Depending on the type of application you choose, the user should be able to do events such as:
Schedule an appointment
Create an Order
Monitor an Order
Purchase a product
View past order history
Search the database
Edit/Update his/her profile
Push data out to a wap-enabled device (later on in the semester)
All the items listed above require interactivity with the database. This laboratory project will get you familiar with creating recordsets to manage data in your backend database. In addition, you will need to cycle through your data and display the information in an html/asp page (or other web format of your choice). The functionality of this interactive application will also enable the user to manipulate his/her data through the application.
The requirements for this lab will be:
Generate an .asp page that pulls data from the database and displays it in an html table
Create a page that will allow the user (once he/she logs in) to create or schedule an event (depending on your industry app)
Maintain this data through SQL commands that allows “inserts, updates, deletes”
Use Do While statement (and Loop) to navigate through the recordset
The lecture portion of this lab will contain various strategies on performing these functions. In addition, the course website will contain documents to support the different requirements for this lab.
Happy Programming