Assignment
Note: Make sure to have the Northwind database installed in your computer.
Program
Develop a multitier (Presentation, Business, and Data tiers) database Web application.
Create a website that allows the user to display customer and order information from the
Northwind database. When the user selects a customer name from a list, the rest of the
information about the customer should display. Include a link called Orders to a second
page that displays a grid of orders for the selected customer. Allow the user with a control
button or from a Menu control to choose and display on a separate page the Suppliers table
in a data grid. Allow the grid to be sorted by Supplier ID, Company Name, Postal Code, and
Country. Include pagination. Select a formatting style for the grid and use appropriate
headers for the columns. Include a Custom Error Page object.
Note: Wait to set the Web.config entry for a custom error page until you know the project
is running correctly.
Project Objectives:
? Develop a multitier database Web application to display records and update database
files.
? Use login controls to validate users.
? Use a parameterized SQL query to select records from a list box.
Fig. 1: Startup screen (partial view).
Fig. 2: Displaying a partial list of customers from the drop down list.
Fig. 3: Result after selecting a customer from the drop down list.
Link to the Orders page
Fig. 4: Opening the link to the orders page for a selected customer (partial view).
Fig. 5: The suppliers (partial view) list.
Link for returning to the Customers
page
Fig. 6: The link to the page number 2 continues the list of customers on the next page
(partial view).
Fig. 7: Sorting by company name (partial view).
Please feel free to send me a message in case of any query
iqra javaid
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]