CS 351: Program 3

20: Excellent Complete Customers and Address tables are displayed on Default.aspx All two linked pages have full functionality Validation controls prevent invalid and or illogical data from being inserted into the database
19, 18: Very Good One of the pages has minor problems
17, 16: Good Two of the web pages have minor problems
15, 14: OK Three of the web pages have minor problems
13, 12, 11, 10: Acceptable: Multiple major problems remain

Student Learning Objectives

Use C# to
- Use C# classes to provide Data Access Layers to access and change data in the corresponding tables in the Day14.mdf database
- Design an web form for interacting with the Customer and the corresponding Address table data

Validate your code and remove any glaring validation and accessibility errors.

Build upon the work done on Day15 by adding CustomersDAL and AddressDAL classes to provide access to the corresponding tables in the database
Display the complete contents of both tables on the Default.aspx page (using your DAL classes and two GridViews)
Provide two links on the Default.aspx page
- Get Customer Details by CustomerId (Default2.aspx)
  - Allow the user to enter a Customer Id and display the corresponding Customer Name and any Addresses associated with that customer
- Add New Customer with zero or more Addresses (Default3.aspx)
  - Allow the customer to add themselves to the database and provide zero or more optional addresses
  - Use asp validator controls on your web page to restrict the user input to legal input
Write the ASP and C# code to implement these actions.

Note: your user interface can use default, bare bones styling. That is, no CSS rules or layout required as long as it is functional.

This program is due at the start of the next Lab (Wednesday)
Save your files in your cs351 U:\nnProgram3 folder where nn is your student account number.
- Remember to copy the the database file to folder App_Data in your nnProgram3 folder
Print out your Default.aspx page as displayed in a browser
Annotate your printout to note
- Any problems that remain in your solution (to assist with grading).
- Your total completion time (rounded to the nearest half-hour)
We will check your program's code, functionality, and the three other pages online

None provided - you may use a minimalist user interface design with this assignment