Assignment 2 – Input Form
Objectives
To create a form that can accept user input and store it in a database.
Assignment
You will need to create a DefaultLoggedIn.aspx page for this – this page will have a link to EditCourse.aspx which is a page where you can enter or edit courses. Right now we will only create a course, later we will add the ability to edit a course using the same form.
A course has 4 fields;
Prefix
Number
Description
Prerequisites
To simplify the database design we will be storing all items in the database as XML. The XML format for the courses will be;
<course>
<prefix>COP</prefix>
<number>4834</number>
<description>Web Systems II</description>
<prerequisites>COP4813</prerequisites>
</course>
Your input form must take the input from user text boxes, validate it, convert it into the correct format, and store it in the database. The XML will be stored in the field DataText in the database. Design information for your database will be found here Default Design for Single Table Database – the DataTypeText will be Course Definition.
NOTE: You may use my default example here as the object that you store – OR – you may create and save objects that you create, this will allow you to work on any projects you may have personally as part of the class.
Information
Estimated Completion Time
Hours typically taken to complete
Supporting Lectures
Topic – Creating a Single Table Database Object Storage