Library Management System


Posted Date:     Total Responses: 0    Posted By: Amit Gupta   Member Level: Bronze   Points/Cash: 0   


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.

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)

  • Project Feedbacks

    Author: Member Level: BronzeRevenue Score: 1 out of 5
    how to download library.sql



    Author: Member Level: BronzeRevenue Score: 1 out of 5
    hey i can not download .sql file pl send me on email id abhildec@yahoo.in


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    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: Member Level: BronzeRevenue Score: 1 out of 5
    please suggests how to download library.sql
    bye
    Ajeeb


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    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: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    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: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi,
    I am unable to download library.sql.please send it to my mail id:dutta.bharathi@gmail.com


    Thank u


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5

    Hi,

    I am not able to download 3-15041-library.sql. Please send this to my id deepasscet@gmail.com




    Author: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    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: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Unable to download the file"3-15041-library.sql ".please forward that file to my mail id "gopan1988@yahoo.com"

    Thanks in Advance


    Author: Member Level: BronzeRevenue Score: 4 out of 54 out of 54 out of 54 out of 5
    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: Member Level: SilverRevenue Score: 5 out of 55 out of 55 out of 55 out of 55 out of 5
    nice project. It working fine.

    Thanks u very much


    Author: Member Level: SilverRevenue Score: 1 out of 5
    can`t download library.sql database file..plz send this to my id karthik_mr@yahoo.co.in


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    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: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi..,

    I am unable to download the file "3-15041-library.sql ".plz forward that file to my mail id "maddianitha@rediffmail.com".





    Author: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    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: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    i can't able to download library.sql file.i will pleased i f send it to my mail shanakrs@gmail.com.thanks


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi,
    I am not able to download "3-15041-library.sql ". Can you please send this on email shane.shrs@gmail.com..

    Thanks!!!


    Author: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    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: Member Level: BronzeRevenue Score: 1 out of 5
    Dear Amit Gupta,
    Here Is the Library SQL file and Library Zip have file same?


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    thank you


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    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: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    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: Member Level: SilverRevenue Score: 2 out of 52 out of 5
    Hi there,

    couldn't download the SQL file.please send it to my email address

    athbati@yahoo.com

    Best reguards
    Thank you



    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    hi

    Unable to download the file"3-15041-library.sql ".please forward that file to my mail id "vamshi.chivakula@gmail.com"


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    am unable to download the file "3-15041-library.sql ".plz forward that file to my mail id "vijayaragavan1982@gmail.com"


    Author: Member Level: GoldRevenue Score: 1 out of 5
    send me the database at waqarnaeem2@hotmail.com


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    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: Member Level: GoldRevenue Score: 1 out of 5
    I ma not able to open download library.sql from he above file.


    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    Hi,
    Very nice projects.
    I am planning to prepare this project.
    Thanks for posting.
    Keep sending such useful projects.


    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    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: Member Level: GoldRevenue Score: 1 out of 5
    i am unable to download file 3-15041-library.sql please help me.


    Author: Member Level: GoldRevenue Score: 3 out of 53 out of 53 out of 5
    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: Member Level: SilverRevenue Score: 2 out of 52 out of 5
    hi,

    its really very useful.will u tell me that whether library.sql and library.zip both files are same.

    Thanx
    Regards,
    Sandeep


    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    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: Member Level: SilverRevenue Score: 2 out of 52 out of 5
    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



    Post Feedback
    You must Sign In to post a feedback.
    Next Project: Course Finder - Search Colleges and Courses
    Previous Project: Student Project - Personal Assistant

    Return to Project Index

    Post New Project



    Top Contributors
    Today
      Last 7 Days
        more...

        Awards & Gifts

        Online Members

        More...
         
        Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India