C# WinForms SQL Student Management System

Project Title:

Student Management System using C# WinForms and SQL Database


---

Objective:

The objective of this project is to develop a Student Management System using C# WinForms (.NET Framework) and SQL Server Database that allows users to manage student information efficiently through a simple and clean desktop interface.


---

Project Description:

The system starts with a login form, where the user enters a valid username and password stored in the database. Upon successful login, the user is directed to the Main Dashboard, which provides different student management operations through labeled buttons.

This project uses SQL Server LocalDB / .mdf file as the backend for data storage. All student records and login credentials are stored and managed in the database. The interface is built using Windows Forms in Visual Studio.


---

Modules / Functions Implemented:

1. Login Module

Authenticates user credentials from the “Users” table in the database.

Redirects to the dashboard on successful login.



2. Add New Student

Allows the user to input student details such as Name, Roll No, Department, Class, DOB, Gender, Contact Number, etc.

Saves the data to the “Students” table in the database.



3. Search Student

Enables searching by Roll No or Name.

Displays student details if found.



4. Update Student Details

Allows editing and updating of student information in the database.



5. Delete Student Record

Deletes a student entry from the database after confirmation.



6. View All Students

Displays all student records in a DataGridView with options to refresh or sort.

Data is directly fetched from the database.



7. Generate Report

Shows summary information such as total number of students, class-wise count, and recently added students.



8. Logout / Exit

Ends the current session and returns to the login screen.





---

Database Design:

Database Name: StudentDB
Tables:

Users (UserID, Username, Password)

Students (StudentID, RollNo, Name, Department, Class, DOB, Gender, Contact, Address, DateAdded)



---

Software & Tools Used:

Language: C# (.NET Framework)

Technology: WinForms

Database: SQL Server / LocalDB (.mdf file)

IDE: Visual Studio 2022 or later

Libraries: Standard .NET Framework only (no external libraries)



---

Key Features:

Clean and classic Windows Forms UI

Easy navigation between modules through dashboard buttons

Database connectivity through ADO.NET

All configuration (like connection strings) stored in App.config for easy modification

Well-structured, well-commented code for better understanding