Reg No:
Name:
Task 1) Open website: https://visualstudio.microsoft.com/downloads/ and download Visual Studio 2022 Community edition (if not installed).
In case of limited resources available on your PC/laptop/notebook you may check https://visualstudio.microsoft.com/vs/older-downloads/ for previous versions.
Run the installer for Visual Studio.
Select ASP.NET and Web Development. Also select .NET Framework project and item templates, .NET Framework 4.6.2-4.7.1 development tools and Additional project templates (previous versions).
Task 2) Go to https://www.microsoft.com/en-us/sql-server/sql-server-downloads and download SQL Server Developer or SQL Server Express edition, follow its instructions for installation.
SQL Server 2022 Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment.
SQL Server 2022 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications.
In case of limited resources check https://learn.microsoft.com/en-us/previous-versions/sql/.
Task 3) Go to website: https://aka.ms/ssmsfullsetup to download SQL Server Management Studio. Install SQL Server Management Studio SSMS by executing SSMS-Setup-ENU file.
Task 4) Consider the project database designed and implemented during previous semester i.e. Fall 2024. Its implementation was done using structured query language during previous semester. Try to recall major relations in your project database. You already have its report in printed form.
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 browser.
Write code to retrieve data from any of your project table. Display a few fields in browser.
Task 5) Connect and query a SQL Server instance using Visual Studio.
Follow the instructions https://learn.microsoft.com/en-us/ssms/quickstarts/ssms-connect-query-sql-server