C# application

Instructions: 1. Make a web application in Visual Studio and name it as A3FirstnameLastname. 2. Create a Web application to display information about categories, products and their order details stored in the Northwind database. • Make sure to use Northwind databased hosted on (LocalDB)\MSSQLLocalDB. Failure to do so would mark assignment invalid as this cannot be evaluated. 3. Use ListBox to display the categories. 4. When a category is selected, its corresponding products are loaded in the DropDownList. 5. When a product is selected, its corresponding order details are loaded in the GridView. • Display the following columns from the Orders table: i. OrderID, OrderDate, ShipedDate, ShipName, ShipAddress, ShipCity, ShipCountry. 6. If a new category is selected from the ListBox, update the products DropDownList accordingly. • And clear the order details GridView. 7. If a new product is selected from the DropDownList, update the order details GridView accordingly. 8. Use AJAX to fetch the data and update the controls. • The page should not reload, but the data should be updated. 9. You should not use any buttons on the form. 10. Give proper names to all the controls used in the form, including the form itself. 11. Customize the form according to your own imagination. You can change the background color, fonts, font color, or whatever you can think of. 12. The very first item in the products DropDownList should be “Select a product”. If no category is selected in the ListBox, DropDownList should still display “Select a product” and should be disabled. 13. In total, you’ll work with these tables from the Northwind database: • Categories • Products • Order Details • Orders