Library Management System using VB.NET and MySQL with Source Code

This is Library Management System is an automated system that is specially designed for school libraries. Its main goal is to help keep the records of every transaction of the books that is available inside the library. It’s a user-friendly system that means all functions are easy to learn and easy to use by the admin and even by occasional users. It also provides reports to know how many books are issued to a particular student. And with this, the librarian can easily track the status of a book and who has borrowed it. Then, it automatically calculates fines for late returns. This does not just provide efficiency but it also frees up more time for other tasks. At the same time, you are confident that all information is well stored in the database.

These are the following features of the system

• Books
  • Add Book
  • Retrieve Books
  • Update Book
  • Delete Book
• Borrower
  • Add New Borrower
  • Retrieve Borrower
  • Update Borrower
  • Delete Borrower
  • Print Library Card
• Transaction
  • Borrow Books
  • Return Books
  • Overdue with Payments
• Category
  • Add New Category
  • Retrieve Categories
  • Update Category
  • Delete Category
• Manage Users
  • Add New User
  • Retrieve Users
  • Update User
  • Delete User
• Report
  • Inventory of Books
    • 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

• xampp latest version
• mysql-connector-net-6.4.4.msi
• mysql-connector-odbc
• Microsoft Visual Studio

Installation

• Download and Extract the source code zip file. (download button is located below)
• Open your XAMPP's Control Panel and start "Apache" and "MySQL".
• Locate the provided SQL file in the extracted source code folder. The file is known as dblibrary.sql.
• Open a browser and browse the PHPMyAdmin. i.e. http://localhost/phpmyadmin
• Create a new database naming dblibrary
• Import the SQL file.
• Locate the Solution file inside the source code folder known as LibrarySystem.sln
• Open the solution file with your MS Visual Studio Software.
• Press the "F5" key on your keyboard to run this Library Management System.

Admin Access Information:

Username: admin
Password: admin

DEMO

That's it! Feel free to modify the source code the way you wanted. I hope this Library Management System Project in VB.NET and MySQL.

For more information about the system. You can contact me @
Email – [email protected]
Mobile No. – 09305235027 – TNT
FB Account – https://www.facebook.com/onnaj.soicalap