CS 351: Lab 4

Three-Tier Architectures

Start up Visual Studio 2005 and create a new ASP.NET Web Site named U:\Labs\nnLab4 where nn is your cs351 account number.
Add an App_Code folder with two subfolders: DAL and BLL
Download the following code into your folders
- DAL
- BLL
Copy an existing or create a Lab4.mdf database on your desktop using the stored procedures from Day 15
- Remember to add and modify a Web Configuration file

On the Default.aspx page, you will need to add the HTML and ASP controls to

Using the BLL classes, display a heading followed by gridview for each of the entire content of each of three tables
- Products
- Orders
- PrderItems
Display a drop down list with the product names followed by a gridview filled with the OrderItem details for the selected product
Display a drop down list with the order IDs followed by a gridview filled with the OrderItem details for the selected order

Add columns to the default gridview appearance to clean up the heading text and format the data displayed inside the columns

Lab 4 is an in-class assignment begun on Wednesday and due by the start of class on Friday

If you finish during lab on Wednesday, get yourself checked off as having completed the lab.
If you are unable to finish during lab, the lab assignment is due Friday. To receive credit:
- Print out and turn in a screen snapshot of your solution running in a browser
- Save you work in your U:\Labs\nnLab4 folder
  - Remember to cut and paste your Lab4.mdf database file from your Desktop to your U:\Labs\nnLab4\app_data folder
- You do not need to print out and submit your C# or ASP.NET code

lab4 screen snapshot