A simple ASP.NET web-form

The Project built with ASP.NET Web Forms and SQL Server to demonstrate basic CRUD operations (Create, Read, Update, Delete).

The application connects to a SQL Server database and allows users to add, view, update, and delete records through a simple web interface.

Features

Add Record → Insert new data into SQL Server from web form.

Read Record → Display all saved records on a webpage, without loading.

Update Record → Modify existing records directly from the interface using the Edit button.

Delete Record → Remove records from the database.

Database setup

Open SQL Server Management Studio (SSMS). Create a new database, e.g., empproject1. Run the following SQL script to create a table:

CREATE DATABASE empproject1; USE empproject1;

CREATE TABLE Employees( id int primary key identity, name VARCHAR(25), age int, city VARCHAR(25), department VARCHAR(40) );

select * from Employees;

-- adding a new column salary and implemented the required changes to the form code.

alter table Employees add salary int;

---

@ Configure Connection String Update the file with your SQL Server details.

🖼️ Project Screenshot