1. Create a web page which can be used to browse, edit, insert, and update the product data in the Northwind database. The Northwind database is included with the SQL server. Create an appropriate header for the web page and add graphics to make the page look professional.
2. Create a web page that displays the category and product data in the Northwind database. It should group the products data by category. Create an appropriate header for the web page and add graphics to make the page look professional.
3. Create a new SQL server database which contains the user information table. The table should contain the following fields:
Create a login page for your web site. The page should have the following controls (all controls must be appropriately labeled):
When the user arrives at the login page check to see if the login cookie exists on the client’s hard disk. If the login cookie exists then read the value of userName and password from the cookie. Verify the login name and password using the user information table. If the user name and password are verified then automatically log the user into the web site and direct them to the login confirmation page. The login information page should display the message: “Welcome Name”, where name is the name of the user as extracted from the database based on the login information. If either the cookie does not exist or it does not contain appropriate value for user name and password then display the login page. Now, when the user clicks on the submit button, after filling in the user name and password fields, verify the user name and password using the user information table. After verification save the user name and password in a client side cookie and redirect the user to login confirmation page as mentioned above. Create an appropriate header for the web page and add graphics to make the page look professional. Set the default focus of the form to User Name text box and default button to Submit button. Set the autocomplete attribute of the form to off so that the user name and password is not saved by the browser