Library Management System(dotnet tutorial)

A simple library management system that provides following facilities login, register, add category, add / remove book, search / issue book, return book. Language used is C# and db is SQL server 2000 and SQL Client has been used in code.

One Admin user is already there once db is installed with user name admin and password admin.

Admin user has extra functionalities like add category, add/remove books. These functionalities can not be done by simple user that registers.

Password encyption - decryption has been used in project. Its very simple project where in all the events of all forms has been handled in Globals.cs that acts as business and data access layer. All DB interactions are in this file only.

As far as db is concerned there are only 4 tables
1. Lib_Users - fields are User_ID,User_Name,User_Password,User_Is_System,User_Created_Date,
Number_Of_Books_Issued

2. Lib_Book_Details - fields are Lib_Book_ID, Lib_Book_Title, Lib_Book_Category,
Lib_Book_Author_Name ,Lib_Book_Issue_Status, Lib_Book_In_Inventory

3. Lib_Book_Issue_Details - fields are Lib_Book_Issue_ID, Lib_Book_ID, Lib_Book_Issued_On,
Lib_Book_Issued_To, Lib_Book_Returned_On

4. Lib_Book_Categories - fields are Category_ID, Category_Name

Screen shots are in word doc Library. Read instructions.txt to install the code.

Architecture is pretty simple as project is very simple. All forms have events and all events needs are sufficed from Globals.cs that is one single point access to DB.

I am working on this to add more features. This will be done soon.

Files Uploaded are - LibraryManagementCode.zip (contains code)
Debug.zip - contains exe
Instructions.txt
library.txt - SQL file
Library.doc - all screen shots

download 3-1584-library.zip, inside it .sql file is present

DOWNLOAD SOUCE CODE
3-15040-LibraryManagementCode.zip (3-15040-LibraryManagementCode.zip)
3-15040-Debug.zip (3-15040-Debug.zip)
3-15041-Library.doc (3-15041-Library.doc)
3-15041-library.sql (3-15041-library.sql)
3-15042-Instructions.txt (3-15042-Instructions.txt)
3-1584-library.zip (3-1584-library.zip)