Lab 4 - Problem Statement

Task 1:

Download Visual Studio 2022

Task 2:

Connect to a SQL Server

Task 3:

Download SQL Server Management Studio

Task 4:

• Create a database of appropriate size using SSMS.
• Create a user and set its authorizations to access the newly created database.
• Using query analyzer, run the SQL script to recreate your project tables and populate with data.
• Alternate option: Restore your project database instead.
• Create a website project using a blank folder as demonstrated in class.
• Add a web form with separate code to the project.
• Test the web form by running it in a browser.
• Write code to retrieve data from any of your project tables and display at least the first five records of any relation in the browser.

Task 5:

Connect and query a SQL Server instance directly using Visual Studio without using SSMS.