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 library.zip - it has sql file
Do not download 3-1584-library.sql instead download 3-1584-library.zip, inside it .sql file is present.
Attachments3-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: ABARNA | Member Level: Bronze | Revenue Score:  |
how to download library.sql
|
Author: abhishek | Member Level: Bronze | Revenue Score:  |
hey i can not download .sql file pl send me on email id abhildec@yahoo.in
|
Author: ajaykumarreddy | Member Level: Bronze | Revenue Score:   |
i am not able to download two files library.sql and instruction.txt. can u please forward then to this mail please. ajaymunna3@gmail.com
|
Author: Ajeeb A J | Member Level: Bronze | Revenue Score:  |
please suggests how to download library.sql bye Ajeeb
|
Author: ankita | Member Level: Bronze | Revenue Score:   |
I am not able to download library.sql.can u plz sent the file at ankita2101@gmail.com
thanks a lot for ur efforts.
|
Author: ankita | Member Level: Bronze | Revenue Score:   |
I am not able to download library.sql.can u plz sent the file at ankita2101@gmail.com
thanks a lot for ur efforts.
|
Author: Bharathi | Member Level: Bronze | Revenue Score:   |
Hi, I am unable to download library.sql.please send it to my mail id:dutta.bharathi@gmail.com
Thank u
|
Author: D.Deepa | Member Level: Bronze | Revenue Score:   |
Hi, I am not able to download 3-15041-library.sql. Please send this to my id deepasscet@gmail.com
|
Author: deepak kumar | Member Level: Bronze | Revenue Score:    |
hello sir how are you . I think you always fine . I have some problems in window based project so please help me
Help me.... I can not download 3-15041-library.sql If any of you r having this file kindly mail me at fastdeepakkumar@gmail.com
|
Author: gopakumar c | Member Level: Bronze | Revenue Score:   |
Unable to download the file"3-15041-library.sql ".please forward that file to my mail id "gopan1988@yahoo.com"
Thanks in Advance
|
Author: gopakumar c | Member Level: Bronze | Revenue Score:     |
Thank for this project.
I am currently attempting to build the project myself based on information from the screen pastes and instruction files only.
Because I was unable to open the database "3-15041-library.sql", but it is nice project. It gave some confident to do a project
Thanks u very much
|
Author: joohitha | Member Level: Silver | Revenue Score:      |
nice project. It working fine.
Thanks u very much
|
Author: Kartik.M.Raguraman | Member Level: Silver | Revenue Score:  |
can`t download library.sql database file..plz send this to my id karthik_mr@yahoo.co.in
|
Author: kishore ch | Member Level: Bronze | Revenue Score:   |
Hi i am unable to download "3-15041-library.sql ".. plz some one forward it to my mail id vnkkishore_ch@rediffmail.com
Thanks&Regards
|
Author: Maddianitha | Member Level: Bronze | Revenue Score:   |
Hi..,
I am unable to download the file "3-15041-library.sql ".plz forward that file to my mail id "maddianitha@rediffmail.com".
|
Author: Reegan Fernando | Member Level: Bronze | Revenue Score:    |
Dear All, I am not able to download the following file, 3-15041-library.sql (3-15041-library.sql).
If any one have that file, please mail me to this mail Id- reeganfdo@hotmail.com.
Thanks in Advance.
With Regards,
Reegan.B
|
Author: shanmuganathan | Member Level: Bronze | Revenue Score:   |
i can't able to download library.sql file.i will pleased i f send it to my mail shanakrs@gmail.com.thanks
|
Author: Shekhar Shrestha | Member Level: Bronze | Revenue Score:   |
Hi, I am not able to download "3-15041-library.sql ". Can you please send this on email shane.shrs@gmail.com..
Thanks!!!
|
Author: shekar | Member Level: Bronze | Revenue Score:    |
hi, Its really a nice project.i am looking forward to execute this.do we need any settings in bin\debug\DBconfig.txt.That partivular file is missing when downloaded.can u please help me out. Please email me at shekar.penugonda@gmail.com
Thanks
|
Author: Devarajan | Member Level: Bronze | Revenue Score:  |
Dear Amit Gupta, Here Is the Library SQL file and Library Zip have file same?
|
Author: subhashini | Member Level: Bronze | Revenue Score:  |
thank you
|
Author: sujata | 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 sujata_12_1982@yahoo.com
|
Author: HajaSha | Member Level: Bronze | Revenue Score:    |
Dear All, I am not able to download the following file, 3-15041-library.sql (3-15041-library.sql).
If any one have that file, please mail me to this mail Id- sweetguyz@gmail.com
Thanks in Advance.
With Regards,
Haja
|
Author: thilani | Member Level: Silver | Revenue Score:   |
Hi there,
couldn't download the SQL file.please send it to my email address
athbati@yahoo.com
Best reguards Thank you
|
Author: vamshikrishna | Member Level: Bronze | Revenue Score:   |
hi
Unable to download the file"3-15041-library.sql ".please forward that file to my mail id "vamshi.chivakula@gmail.com"
|
Author: Vijayaragavan.R | Member Level: Bronze | Revenue Score:   |
am unable to download the file "3-15041-library.sql ".plz forward that file to my mail id "vijayaragavan1982@gmail.com"
|
Author: Ali | Member Level: Gold | Revenue Score:  |
send me the database at waqarnaeem2@hotmail.com
|
Author: zeeshan | Member Level: Bronze | Revenue Score:   |
Hi,
i am unable to download this •3-15041-library.sql (3-15041-library.sql) please anyone send me on this id: zeeshansabir@ymail.com
thanks in advance. regards
|
Author: Arun Gandhi | Member Level: Gold | Revenue Score:  |
I ma not able to open download library.sql from he above file.
|
Author: Bunty | 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: 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: gopi2raju | Member Level: Gold | Revenue Score:  |
i am unable to download file 3-15041-library.sql please help me.
|
Author: Hefin Dsouza | Member Level: Gold | Revenue Score:    |
3-15041-library.sql does not Download Please Check it.
Please Email me the file. initiotech@gmail.com
Good Logic. Also Can any one send me the SRS(System Requirement Specification) Report for this Application
Regards Hefin Dsouza
|
Author: sandeep | Member Level: Silver | Revenue Score:   |
hi,
its really very useful.will u tell me that whether library.sql and library.zip both files are same.
Thanx Regards, Sandeep
|
Author: siva | Member Level: Gold | Revenue Score:   |
Hi, Its really nice. I would like learn such type of things.
It will be greatful for me to send the files.
Thanks Rakesh, Siva Sreenath
|
Author: vairamuthu | Member Level: Silver | Revenue Score:   |
Unable to download the file"3-15041-library.sql ".plz forward that file to my mail id "vaira20ster@gmail.com"
Thanks in Advance,
Vaira Muthu
|