EmployeeManagementSystem-AspNet

💼 Employee Management System

.NET Framework 4.7.2  •  SQL Server (SSMS)  •  Bootstrap 5

---

CRUD & Pagination  •  Advanced Search  •  Validation  •  Responsive UI

---

🚀 Manage Employees Efficiently • Streamlined CRUD Operations • Modern UI 💻

A comprehensive Employee Management System built with ASP.NET Web Forms and ADO.NET, providing complete CRUD operations with a modern, responsive interface.

🚀 Overview

This is a feature-rich Employee Management System that demonstrates classic ASP.NET Web Forms development with server-side rendering and direct database interaction. The application provides all essential CRUD (Create, Read, Update, Delete) functionalities wrapped in a user-friendly and modern interface.

✨ Key Features

🔧 Core Functionality

• Complete CRUD Operations - Add, View, Edit, and Delete employee records seamlessly
• Dynamic Data Grid - Employee data displayed in a clean, sortable GridView control
• Intelligent Form Handling - Single form that dynamically switches between Add and Update modes

🔍 Advanced Search & Navigation

• Robust Search Functionality - Filter records across multiple fields (ID, Name, Email, Contact, Address)
• Server-Side Pagination - Efficient handling of large datasets with custom navigation controls
• Dynamic Record Display - Configurable records per page (5, 10, 20, 50 options)
• Real-Time Filtering - Search results update dynamically as you type

🎨 User Experience

• Responsive Design - Built with Bootstrap 5 for modern, mobile-friendly interface
• Real-Time Feedback - Success and error messages with auto-fade functionality
• Form Pre-Population - Automatic data loading when editing existing employees
• Dual Validation - Both client-side JavaScript and server-side ASP.NET validation

🛠️ Technologies Used

Technology	Purpose
C# / ASP.NET Web Forms	Backend framework (.NET Framework 4.7.2)
ADO.NET	Database connectivity and operations
Microsoft SQL Server	Primary database engine
Bootstrap 5	Frontend styling and responsiveness
JavaScript	Client-side interactions and validation
GridView, UpdatePanel	Server-side controls for data display

📸 Application Screenshots

🏠 Home Page / Employee Directory

Main dashboard displaying employee list with search, pagination, and action controls

➕ Add New Employee

Clean, intuitive form for adding new employees to the system

✏️ Update Employee

Pre-populated form for editing existing employee information

🔎 Search Functionality

Dynamic search filtering across multiple employee fields

🔧 Setup and Installation

Prerequisites

• Visual Studio 2019 or later
• .NET Framework 4.7.2
• Microsoft SQL Server (Express or higher)

1. 🗄️ Database Setup

Create the database and employee table by executing the following SQL script:

CREATE DATABASE EmployeeManagement;
GO

USE EmployeeManagement;
GO

CREATE TABLE Employees (
    Id INT PRIMARY KEY IDENTITY(1,1),
    Name NVARCHAR(255) NOT NULL,
    Email NVARCHAR(255) NOT NULL UNIQUE,
    ContactNumber NVARCHAR(50) NULL,
    Address NVARCHAR(500) NULL
);
GO

2. ⚙️ Configure Connection String

Update the Web.config file with your SQL Server connection details:

<connectionStrings>
  <add name="EmployeeDB"
       connectionString="Data Source=YOUR_SERVER_NAME;Initial Catalog=EmployeeManagement;Integrated Security=True;"
       providerName="System.Data.SqlClient" />
</connectionStrings>

Note: Replace YOUR_SERVER_NAME with your SQL Server instance name (e.g., AMAAN-PC\SQLEXPRESS01, localhost, etc.)

3. 🚀 Run the Application

1. Open AmaanCRUD2.sln in Visual Studio
2. Build the solution (Build → Build Solution)
3. Set Default.aspx as the start page
4. Press F5 or click Run to launch the application

🎯 Key Features Breakdown

📊 Dynamic Pagination

• Flexible Record Display - Choose between 5, 10, 20, or 50 records per page
• Smart Navigation - Previous/Next buttons with page information
• Performance Optimized - Server-side pagination for efficient data handling

🔍 Advanced Search System

• Multi-Field Search - Search across ID, Name, Email, Contact Number, and Address
• Real-Time Results - Instant filtering as you type
• Case-Insensitive - Flexible search matching

📝 Form Intelligence

• Mode Detection - Automatically switches between Add and Update modes
• Data Pre-Population - Existing employee data loads automatically for editing
• Validation Stack - Client-side and server-side validation for data integrity

🏗️ Project Structure

EmployeeManagementSystem-AspNet/
├── Default.aspx              # Main page with employee grid
├── Default.aspx.cs           # Code-behind for main functionality  
├── Web.config               # Application configuration
├── Outputs/                 # Screenshot directory
│   ├── Home Page.jpg
│   ├── Add Employee.jpg
│   ├── Update Employee.jpg
│   └── Search Employee.jpg
└── bin/                     # Compiled assemblies

🤝 Contributing

1. Fork the repository
2. Create your feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

📄 License

This project is open source and available under the MIT License.

👨‍💻 Author

Amaan - GitHub Profile

---

⭐ Star this repository if you find it helpful!