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
 Attachments
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)
|
| Author: joohitha | Member Level: Silver | Revenue Score:  |
nice project. It working fine.
Thanks u very much
|
| Author: Anil | Member Level: Bronze | Revenue Score: |
Hello frinds..This is anil kumar kanchanapalli,could you please send the abstract for Library Management System (including the code as separate,Database,code)....and also please send these step bye steps manner...
|
| Author: Lokesh | Member Level: Bronze | Revenue Score: |
gr8...
post more projects...
|
| Author: Deepa | Member Level: Gold | Revenue Score: |
Thanks,its working fine.
but i have to do some more changes according to requirement but still thanks for your project.
Thanks & Regards,
Deepa
|
| Author: Satyanarayan SushilKumar Bajoria | Member Level: Gold | Revenue Score: |
Hi,
Very nice projects.
I am planning to prepare this project.
Thanks for posting.
Keep sending such useful projects.
|
| Author: Ritik D Dodhiwala | Member Level: Bronze | Revenue Score: |
Help me....
I can not download 3-15041-library.sql
If any of you r having this file kindly mail me at ritikdodhiwala@yahoo.co.in
|
| Author: wilson francis | Member Level: Bronze | Revenue Score: |
i cant seem to download this sql file "3-15041-library.sql ". any one who can help me with a copy? my email add is wilsonflex@yahoo.com
|
| Author: Raj | Member Level: Bronze | Revenue Score: |
hi group,
am unable to download the file "3-15041-library.sql ".plz forward that file to my mail id "k84.krishna@gmail.com"
|