Instructions:
1. Make a web application in Visual Studio and name it as FinalFirstnameLastname.
2. Design and implement a webpage where a user can find all the products based on a category or a supplier.
3. Use Northwind database for this application.
4. The webpage displays two DropDownList controls (See screenshots on other pages).
5. One DropDownList control displays all the category names (from the Categories table in the database), and the other DropDownList control displays all the supplier names (from the column Company Name in the Suppliers table).
6. On selecting a category from the categories DropDownList, fetch and display all the products in the GridView that belong to the selected category.
7. On selecting a supplier from the suppliers DropDownList, fetch and display all the products in the GridView that belong to the selected supplier.
8. The products should be fetched on selecting an item from the DropDownList, not on any button's click event.
9. The following columns from the database table Products should be fetched and displayed:
10. You need to use three tables for this application: Products, Categories and Suppliers.
11. The following image shows the relationship between these tables: see image.
12. If a new category or supplier is selected in the DropDownList, update the products GridView accordingly.
13. The very first item in the DropDownLists should be "Select a category" and "Select a supplier" respectively.
14. If a supplier is selected after selecting a category, then reset the category DropDownList to "Select a category", and vice-versa.
15. You should not use any buttons on the form.
16. Give proper names to all the controls used in the form, including the form itself.
17. Customize the form according to your own imagination. You can change the background color, fonts, font color, or whatever you can think of.
18. Apply CSS to the webpage.
Requirements:
Screenshots:
Screenshot 1: see image.
Screenshot 2: see image.