Lab 4 Details

Problem Statement

This lab focuses on the foundational setup required for a web-based database project. It begins with the installation of essential development tools, namely Visual Studio and SQL Server Management Studio (SSMS). Once the environment is ready, students are tasked with creating a new database in SSMS, configuring a user account with appropriate permissions, and either executing an SQL script to reconstruct the existing project schema and data or restoring a previously saved database. The next step involves initiating a web project using a blank folder in Visual Studio, followed by the creation of a web form with a code-behind file. Finally, the application must be connected to the database to retrieve and display a minimum of five records from a chosen relation, such as a Customer table, thereby completing the initial integration between the front-end and back-end components.

Code Implementation Report

Sample Outputs