Mt. San Jacinto College Computer Information Systems
Minimize header.

CSIS 116B: Developing ASP.NET Web Applications

Final Assignment

Rubric

Your Website application must meet the following criteria:
  1. All of the criteria from the Midterm exam is completed and assignment URL is submitted on time. (5 points)
  2. Add a new Web Form (based on your masterpage) named Customers to the root of your site (add a link for it in your navigation system) and add to it a GridView control displaying the contents of the Northwind Customer table. Set the default sort order of the Customer's table to 1) CompanyName, 2) ContactName, then 3) ContactTitle. Allow paging of the data and display 20 records per page and make it so that the GridView can be sorted alphabetically on each column. (5 points) Camtasia Version
  3. Change each of the GridView column headers to have a heading other than the field name and limit the fields displayed to: CustomerID, CompanyName, ContactName, ContactTitle, phone, and fax. Convert the ID Field in the GridView to a template field containing a Hyperlink server control that, when clicked, opens a WebForm named CustomerDetails, which contains a FormView server control displaying the details of the record specified in a QueryString. (5 points) Camtasia Version
    GridView ItemTemplate for the CustomerID field.
    In case you're interested, here is more information on using Eval() & Bind() in data-binding expressions.
  4. Create a new Web Form named CustomerDetails, add a FormView server control to it and then configure it to display the Customer table where the queryString value for cid is equal to the CustomerID field of the record being displayed in the FormView control.  (5 points) Camtasia Version
  5. Create a new table in your student database named ContactForm. Add an ID field as a required int, make ID the  primary key and enable identity insert mode. Also add a name field configured as varchar(150) required, an address field configured as varchar(150), a city field configured as varchar(150) , a state field configured as a varchar(2), a zip_code field as varchar(7), a phone field as varchar(10), and an email field as varchar(150) Required.
    Note: You will need to add at least one record to your ContactForm table using the SQL Server Object Explorer, Server Explorer, or SQL Server Management Studio, before you will see a Web Form control, like a FormView control, appear in a Web form when viewing in a Web browser; i.e. if you can't see your form in the Web browser, it's most likely because you did not add a record to your table. View Web-based Tutorial  (5 points)
  6. Open your ContactForm and edit it so that all Label and TextBox controls are moved into a FormView control which can edit, insert, and display records in the ContactForm table. View Web-based Tutorial  (5 points)
  7. Add a RequiredFieldValidator to your FormView control for the Name and Email TextBox controls in both the InsertItemTemplate and the EditItemTemplate templates of the FormView control. Add a RegularExpressionValidator to ensure the Email TextBox entry contains a properly formatted email address in both the EditItemTemplate and InsertItemTamplate templates. View Web-based tutorial (5 points)
  8. Create a new table in your student database named Resources. Add an ID field as a required int, make ID the primary key and enable identity insert mode. Also add, a title field configured as varchar(50) required, a description field configured as varchar(max), and a URL field configured as varchar(255) Required. (Same procedure as Step 5). (5 points) View Resources Table Configuration in Design View
  9. Add a new Web Form (based on your masterpage) named Resources to the root of your site (add a link for it in your navigation system) and add a FormView control to it which can edit, insert, and display records in the Resources table. Add a RequiredFieldValidator to your FormView control for the title and URL fields. Add a RegularExpressionValidator to ensure the URL entry contains "http://".  Create several records in your table based on Internet-based resources about ASP.NET Web development (3 to 4 is enough). View Web-based Tutorial (5 points)
  10. Add a new folder to your project named Controls. Add a new User Control to the Controls folder named ResourcesListView. Add a Repeater control to your user control and configure it to display each record from the Resources table in a formatted HTML structure. Add a new Web Form (based on your masterpage) named ViewResources to the root of your site (add a link for it in your navigation system) and add your ResourcesListView user control to the ViewResources Web form. View Web-based Tutorial (5 points)