Library Management System

Project Overview

The Library Management System is a web-based application developed using ASP.NET Web Forms and C#. It helps libraries manage books, students, book issuing, returns, and fine calculations efficiently. The system provides separate functionalities for administrators and students to automate daily library operations.

---

Project Name

Library Management System

---

Developed By

Vrajkumar Pankajbhai Patel

B.Sc. Information Technology

Shree Ramkrishna Institute of Computer Education and Applied Sciences

---

Technologies Used

Frontend

• ASP.NET Web Forms
• HTML5
• CSS3
• Bootstrap 5

Backend

• C#

Database

• SQL Server

Data Access

• ADO.NET

Development Tools

• Visual Studio 2022
• SQL Server Management Studio (SSMS)

---

Features

Admin Module

• Admin Login
• Dashboard
• Add New Books
• Edit Book Details
• Delete Books
• View All Books
• Issue Books
• Return Books
• Fine Calculation
• Search Students
• Search Issued Books
• Generate Reports
• Export Reports to Excel
• Logout

Student Module

• Student Registration
• Student Login
• Search Books
• View Available Books
• Student Dashboard

Additional Features

• Session Management
• Validation Controls
• Bootstrap Responsive Design
• Master Page Implementation
• SQL Server Integration

---

Database Tables

Admins

• AdminID
• Username
• Password

Books

• BookID
• BookName
• Author
• Category
• Quantity

Students

• StudentID
• StudentName
• Email
• Mobile
• Password

IssueBooks

• IssueID
• StudentID
• BookID
• IssueDate
• DueDate
• ReturnDate
• Status
• FineAmount

---

Screenshots

Add screenshots of the following pages:

1. Admin Login Page
2. Admin Dashboard
3. Add Book Page
4. Manage Books Page
5. Student Registration Page
6. Student Login Page
7. Search Book Page
8. Issue Book Page
9. Return Book Page
10. Reports Page

Example:

screenshots/
├── login.png
├── dashboard.png
├── addbook.png
├── managebooks.png
├── issuebook.png
└── reports.png

---

Database Setup

Step 1: Create Database

Open SQL Server Management Studio and execute:

CREATE DATABASE LibraryDB;

Step 2: Use Database

USE LibraryDB;

Step 3: Execute all table creation scripts included in the project.

Step 4: Insert Default Admin

INSERT INTO Admins
VALUES ('admin','admin123');

---

How to Run the Project

Prerequisites

• Visual Studio 2022
• SQL Server Express or SQL Server
• SQL Server Management Studio (SSMS)
• .NET Framework 4.8

Steps

1. Clone Repository

git clone https://github.com/yourusername/Library-Management-System-ASP.NET.git

2. Open Solution

Open the .sln file using Visual Studio.

3. Restore Database

Create the database and tables using the provided SQL scripts.

4. Update Connection String

Open Web.config and modify:

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

Replace YOUR_SERVER_NAME with your SQL Server instance name.

5. Build the Project

In Visual Studio:

Build → Build Solution

Shortcut:

Ctrl + Shift + B

6. Run the Project

Press:

Ctrl + F5

---

Default Admin Credentials

Username:

admin

Password:

admin123

---

Future Enhancements

• Email Notifications
• Barcode Scanner Integration
• Book Reservation System
• Password Encryption
• PDF Report Generation
• Role-Based Authentication

---

Learning Outcomes

Through this project, I gained practical knowledge of:

• ASP.NET Web Forms
• ADO.NET
• SQL Server Database Design
• CRUD Operations
• Session Management
• Validation Controls
• Bootstrap Integration
• Report Generation
• GitHub Project Management

---

License

This project is developed for educational purposes and can be freely used for learning and academic demonstrations.

---

Contact

Vrajkumar Pankajbhai Patel

Email: vrajp741@gmail.com

GitHub: https://github.com/vraj2512