develop a Web form that displays all of the orders for a given customer ID from the Northwind database

/in /by

develop a Web form that displays all of the orders for a given customer ID from the Northwind database

In this project, you will use the ASP.NET GridView data control and the SqlDataSource control to develop a Web form that displays all of the orders for a given customer ID from the Northwind database.

Download the Northwind database from this URL:

 

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

Read and follow the installation instructions of the Northwind database, and then add the “Northwind.mdf” file to your ASP.NET Web site under the “App_Data” folder. Your App_Data folder should look like this:

Use your Web site home page (default.aspx) to develop this project (no need to create a new Web form). Your project should accept a customer ID from the user and then display all of the orders in the Northwind database that this customer has ordered. Display these columns from the Orders table:

  • OrderID
  • OrderDate
  • EmployeeID
  • ShipCity
  • ShipRegion
  • ShipCountry

Your form should look like the following form:

Project Deliverable:

  • A Word document containing a description of the steps you performed to complete the project, along with a screenshot of your home page when requested by the browser
  • A zip file of all of your Visual Studio project files so that it can be reproduced on a different computer