School Library System Using C# and MySQL Database Free Source Code



This Library system is an automated system that aims to simplify the way of issuing a book, save time and effort. With the use of this system, you can properly keep records of books issued, reissued, and those not returned. This eliminates the need to employ many workers because with the help of this system the librarian can accomplish the daily transactions by himself at a given time. This is an easy-to-use system that will enhance the efficiency of the library.


This Library System Free source code was developed using C#, MySQL Database, and SAP Crystal Reports. In this software, the librarian can list all the books along with some book details and can be easily retrieved. The software handles Borrowing and Returning Books Transaction of the Library. This has also a feature that manages Over Due Return Book that has a simple calculator that calculates/computes the borrower's penalty base to the penalty amount of the book. The software also generates reports which are the daily, weekly, monthly, and day wise transaction report and book list.

These are the following features of the system

  • Manage Books
  • Manage Borrowers
  • Manage Transactions
  • Manage Book Categories
  • Manage Users
  • Inventory Reports
    • List of Books
    • Total Number of Books
    • Daily
    • Weekly
    • Monthly
    • Inclusive Dates
  • User Logs
  • Login and Logout

How to Run

Requirements: (Download and Install the following)


  1. Open your XAMPP/WAMP's Control Panel and start the Apache and MySQL.
  2. Extract the downloaded source code zip file.
  3. Locate the provided SQL file provided on the extracted source code folder.
  4. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
  5. Create a new database naming dblibrary.
  6. Import the provided SQL file. The file is known as dblibrary.sql.
  7. Locate the Solution File in the extracted source code folder. The file is known as LibrarySystem.sln.
  8. Open the solution file with your MS Visual Studio Software.
  9. Press the F5 key on your keyboard to run the Library System Software

Access this system using the admin account:

Username: admin
Password: admin


That's it! You can now explore the features and functionalities of this Library System in C#. I hope this will help you with what you are looking for and for your future C# Projects.

Explore more on this website for more updates and free source codes.

For more information about the system. You can contact me @
Email [email protected]
Mobile No. – 09305235027 – TNT
FB Account –
Or feel free to comment below.

Enjoy :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Submitted bymed ft (not verified)on Wed, 10/30/2019 - 05:32

good job my friend

Add new comment