Library Management System


Posted Date:     Total Responses: 0    Posted By: Abhisek Panda   Member Level: Gold   Points/Cash: 40   


It is a simple Library Management System developed using C# as frontend and MS SQL Server2000 as backend. It provides separate view for the user and administrators with good user interface. The administrator can view several reports. For security purpose it uses encryption/decryption.It also maintain inventory.

It has four tables

Lib_User

Field Name Type Length(bytes) Constraint
User_ID int 4 Primary Key
User_Name varchar 120 Not Null
User_Password varchar 120 Not Null
User_Is_System bit 1 Not Null
User_Created_Date datetime 8 Not Null
Number_Of_Books_Issued int 4 Not Null


Lib_Book_Categories

Field Name Type Length(bytes) Constraint
Category_ID int 4 Primary Key
Category_Name varchar 120 Not Null


Lib_Book_Details

Field Name Type Length(bytes) Constraint
Lib_Book_ID int 4 Primary Key
Lib_Book_Title varchar 120 Not Null
Lib_Book_Category int 4 Not Null
Lib_Book_Author_Name varchar 120 Not Null
Lib_Book_Publisher_Name varchar 120 Not Null
Lib_Book_PublisAt_Name varchar 120 Not Null
Lib_Book_YearPubish int 4 Not Null
Lib_Book_Edition int 4 Not Null
Lib_Book_Volume int 4 Not Null
Lib_Book_Page int 4 Not Null
Lib_Book_Price float 8 Not Null
Lib_Book_Issue_Status bit 1 Not Null
Lib_Book_In_Inventory bit 1 Not Null

Lib_Book_Issue_Details

Field Name Type Length(bytes) Constraint
Lib_Book_Issue_ID int 4 Primary Key
Lib_Book_ID int 4 Not Null
Lib_Book_Issued_On datetime 8 Not Null
Lib_Book_Issued_To varchar 120 Not Null
Lib_Book_Returned_On datetime 8 Null


It provides facility to register a new user and login with that password. The user can search a book and issue it to him, return books and change his password.

The administrators has some additional functions such as add/remove book, add category, view reports,etc.

In this project I have included tabbed window which help the user to do multiple tasks in a single window.

The default login name is "admin" and password is "admin" after executing the Library.sql.

You have to first create the database and execute the project, otherwise it will not work.

The source code, screen-shots and database files are below.






Attachments

  • Login (687-7928-Login.bmp)
  • Admin Access (687-7929-Adminacess.bmp)
  • User Access (687-7930-User.bmp)
  • Report (687-7931-BookDetails.bmp)
  • Database (687-7925-library.sql)
  • Database(New) (687-12853-library.sql)
  • Source Code (687-7921-Library Management.zip)
  • Screen Shots (687-7927-Library screenshots.zip)
  • Library.sql Zip File (687-17938-library.zip)

  • Project Feedbacks

    Author: Member Level: BronzeRevenue Score: 1 out of 5
    send me database plz


    Author: Member Level: SilverRevenue Score: 2 out of 52 out of 5
    Hi Abhi,
    library.sql link is not working . Could you plz send me this project to my email address:
    chotoapa@yahoo.com
    i would appreciate your help.


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi Iam Arun , the link for Database is not working.
    please mail the database file to ece.arun.s@gmail.com


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    kindly mail me complete project at email : aasha1000@rediffmail.com


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi abhi dis new database file also not workin
    library.sql...
    plz send me dis file on my eid-abhishek19_gandhi@yahoo.co.in


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi Abhisek Panda, Iam trying to download the database file its not working....

    Can you pls check this and send the file pls....

    My mail id - mailtoamar@aol.com


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    hell friend can u send me the data base to this project urgent required my id ashok.pudota@gmail.com


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    Hi,
    can some one u send me the database files anusud@yahoo.in
    -anil


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

    I am unable to download this
    (687-7925-library.sql) please send me this on my id: da_as2001@rediffmail.com

    Thanks in advance
    regards


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    please tell me your phone number please please please


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    please give me your cell no , i need to submit project urgent please i want to talk to you please


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    please give me your cell no , i give small money to buy this project totally please please


    Author: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    hi,
    I am Chitta from West Bengal.your project is excellent. I am really impressed on your project. The link for Database is not working.
    please post me the database file to chittaranjanghosh@rocketmail.com.

    thank u.........



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

    m unable to download database.. :(
    please send me database to my e-mail:- devarsh_027@yahoo.com



    thanks
    devarsh


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    sir,
    i need library management system project in vb6.0... pls send me to this email id.. eswarankalai@gmail.com


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    helloo
    pls send me ur project my email id is gaikwad.vidya02@gmail.com


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    hi
    i am gani from chennai.your project desidn is good ,plz send database file in my mail id gani_kh@yahoo.co.in
    thanking you


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    its a very nice screen shot please send me the DATA FLOW DIAGRAM OR THE DATA MODELING @ gierald1112@yahoo.com


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

    I am unable to download this
    (687-7925-library.sql) please send me this on my id: jasbeer_jesy_07@yahoo.com



    Author: Member Level: BronzeRevenue Score: 1 out of 5
    kindly requested to u please can u send me full project... with source code & documentation.


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    kindly requested to u please can u send me full project... with source code & documentation.
    ID:mahimai1717@gmail.com


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi Abhishek,
    library.sql link is not working . Could you plz send me this project to my email address:
    manishrajhans58@gmail.com
    i would appreciate your help.



    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi shaan
    library.sql link is not working . Could you plz send me this project to my email address:
    minalsinkar@gmail.com



    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    hi dis is monika.........

    I am unable to download this
    plz send dis to mail spandana.monika@gmail.com

    In advance Thanq


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi,
    please send the database (687-7925 library.sql) to my mail. Since i am not able to download it from here. I will be very thankfull for your help. My email id is mvmounika305@gmail.com



    Author: Member Level: BronzeRevenue Score: 1 out of 5
    gud project


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


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    thanx.. for ur help


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    kindly mail me complete project at email ranjan.sayal93@gmail.com



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

    I have tried a lot to download the database file but the links are not working.

    Could you please provide a link.

    Many Thanks

    Rao


    Author: Member Level: GoldRevenue Score: 1 out of 5
    Here is the new database file,


    library.sql
    Author: Member Level: GoldRevenue Score: 1 out of 5
    Please check the database file here. In others the download link is not working.


    library.sql
    Author: Member Level: GoldRevenue Score: 5 out of 55 out of 55 out of 55 out of 55 out of 5
    I would like to say sorry for the late feedback. I have contacted webmaster of DNS to correct the problem.

    Here is the database file contents.


    CREATE DATABASE [Library] ON (NAME = N'Library_Data', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL\data\Library_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'Library_Log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL\data\Library_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
    COLLATE SQL_Latin1_General_CP1_CI_AS
    GO
    use [Library]
    GO
    CREATE TABLE [dbo].[Lib_Book_Categories] (
    [Category_ID] [int] IDENTITY (1, 1) NOT NULL ,
    [Category_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[Lib_Users] (
    [User_ID] [int] IDENTITY (1, 1) NOT NULL ,
    [User_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [User_Password] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [User_Is_System] [bit] NOT NULL ,
    [User_Created_Date] [datetime] NOT NULL ,
    [Number_Of_Books_Issued] [int] NOT NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[Lib_Book_Details] (
    [Lib_Book_ID] [int] IDENTITY (1, 1) NOT NULL ,
    [Lib_Book_Title] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Lib_Book_Category] [int] NOT NULL ,
    [Lib_Book_Author_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Lib_Book_Publisher_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Lib_Book_PublisAt_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Lib_Book_YearPubish] [int] NULL ,
    [Lib_Book_Edition] [int] NULL ,
    [Lib_Book_Volume] [int] NULL ,
    [Lib_Book_Page] [int] NULL ,
    [Lib_Book_Price] [float] NULL ,
    [Lib_Book_Issue_Status] [bit] NULL ,
    [Lib_Book_In_Inventory] [bit] NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[Lib_Book_Issue_Details] (
    [Lib_Book_Issue_ID] [int] IDENTITY (1, 1) NOT NULL ,
    [Lib_Book_ID] [int] NOT NULL ,
    [Lib_Book_Issued_On] [datetime] NOT NULL ,
    [Lib_Book_Issued_To] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [Lib_Book_Returned_On] [datetime] NULL
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Book_Categories] WITH NOCHECK ADD
    CONSTRAINT [PK_Lib_Book_Categories] PRIMARY KEY CLUSTERED
    (
    [Category_ID]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Users] WITH NOCHECK ADD
    CONSTRAINT [PK_Lib_Users] PRIMARY KEY CLUSTERED
    (
    [User_ID]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Book_Details] WITH NOCHECK ADD
    CONSTRAINT [PK_Lib_Book_Details] PRIMARY KEY CLUSTERED
    (
    [Lib_Book_ID]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Book_Issue_Details] WITH NOCHECK ADD
    CONSTRAINT [PK_Lib_Book_Issue_Details] PRIMARY KEY CLUSTERED
    (
    [Lib_Book_Issue_ID]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Users] WITH NOCHECK ADD
    CONSTRAINT [DF_Lib_Users_User_Is_System] DEFAULT (0) FOR [User_Is_System],
    CONSTRAINT [DF_Lib_Users_User_Created_Date] DEFAULT (getdate()) FOR [User_Created_Date],
    CONSTRAINT [DF_Lib_Users_Number_Of_Books_Issued] DEFAULT (0) FOR [Number_Of_Books_Issued],
    CONSTRAINT [IX_Lib_Users] UNIQUE NONCLUSTERED
    (
    [User_Name]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Book_Details] WITH NOCHECK ADD
    CONSTRAINT [DF_Lib_Book_Details_Lib_Book_Issue_Status] DEFAULT (0) FOR [Lib_Book_Issue_Status],
    CONSTRAINT [DF_Lib_Book_Details_Lib_Book_In_Inventory] DEFAULT (1) FOR [Lib_Book_In_Inventory]
    GO
    ALTER TABLE [dbo].[Lib_Book_Issue_Details] WITH NOCHECK ADD
    CONSTRAINT [DF_Lib_Book_Issue_Details_Lb_Book_Issued_On] DEFAULT (getdate()) FOR [Lib_Book_Issued_On]
    GO
    ALTER TABLE [dbo].[Lib_Book_Details] ADD
    CONSTRAINT [FK_Lib_Book_Details_Lib_Book_Categories] FOREIGN KEY
    (
    [Lib_Book_Category]
    ) REFERENCES [dbo].[Lib_Book_Categories] (
    [Category_ID]
    )
    GO
    ALTER TABLE [dbo].[Lib_Book_Issue_Details] ADD
    CONSTRAINT [FK_Lib_Book_Issue_Details_Lib_Book_Details] FOREIGN KEY
    (
    [Lib_Book_ID]
    ) REFERENCES [dbo].[Lib_Book_Details] (
    [Lib_Book_ID]
    ),
    CONSTRAINT [FK_Lib_Book_Issue_Details_Lib_Users] FOREIGN KEY
    (
    [Lib_Book_Issued_To]
    ) REFERENCES [dbo].[Lib_Users] (
    [User_Name]
    )
    GO
    insert into Lib_Users (user_name,user_password,user_is_system)values('admin','YWRtaW4=',1)



    You may need it in future. To run the project first run the above script file in SQL Server 2000. Then in Visual studio IDE run the project. The report section might not work due to change of location. You have to build it again.



    Author: Member Level: GoldRevenue Score: 1 out of 5
    Hi Friends,

    Please download •Library.sql Zip File (687-17938-library.zip) file. It is working.


    Author: Member Level: SilverRevenue Score: 2 out of 52 out of 5
    Hi,

    Please send me this project with full documentation on ankur.arora17@yahoo.co.in.
    I really need this project urgently.
    Your help would be highly appreciable.

    Thanks,

    Ankur


    Author: Member Level: GoldRevenue Score: 1 out of 5
    good project.

    -- Manisha Chaubey


    Author: Member Level: SilverRevenue Score: 1 out of 5
    send me database plz
    smilerathor@gmail.com

    thanks


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    hi abhisek

    nice projects. thanx for ur efforts. pls tel mi hw it wil run.


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    hiiiiiiii...am sai srinivas

    am unable to run the project...can u plz suggest me ....how to run


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    hiiiiiiii...am sai srinivas

    am unable to run the project...can u plz suggest me ....how to run


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    hiiiiiii abhi
    can u plz send me the project to my mail ...leaderstrong@gmail.com

    plz send me



    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    its a very nice project but library.sql is not working. could you plz send me the DATA FLOW DIAGRAM OR THE DATA MODELING at nagendra.nagala@gmail.com


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Dear
    Abhisek Panda

    At this moment the Dotnet Spider does not support to download .sql, .docx and etc formatted files.

    So u can upload the database in zip format.

    Thanks
    Shahdat






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

    I am unable to download this
    (687-7925-library.sql) please send me this on my id: shanid360@gmail.com

    Thanks in advance
    regards



    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi shaan
    library.sql link is not working . Could you plz send me this project to my email address:
    shanid360@gmail.com
    i would appreciate your help.


    Author: Member Level: BronzeRevenue Score: 3 out of 53 out of 53 out of 5
    hi,
    I am shanmugam from chennai.your project is good. I am very much impressed on your project. The link for Database is not working.
    please post me the database file to shanmugamnk@gmail.com.

    thank u.........





    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
    Siva Sreenath


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi Abhisek,
    Please send the library.sql to me by mail smilekapoor[at]gmail[dot]com

    Your link is not working :(


    Author: Member Level: SilverRevenue Score: 3 out of 53 out of 53 out of 5
    Hai,

    I have tried a lot to download the database file but the links are not working.Could you please provide a link.And please send me the DATA FLOW DIAGRAM OR THE DATA MODELING in my mail:sudhanthira.l@gmail.com


    Author: Member Level: SilverRevenue Score: 1 out of 5
    why you are using static only..Any Specific Reason you are using static..i cant run your project..pls send my mail..


    Author: Member Level: SilverRevenue Score: 1 out of 5
    i need source code for fine calculation in Library Management System...


    Author: Member Level: BronzeRevenue Score: 1 out of 5
    Thanks for Sharing its working


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi Iam Yuen , the link for Database is not working.
    please mail the database file to yt56ku78@gmail.com


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    hi Abhisek
    it looks good project
    could you please email me this project with documnetation on softprogrammer2003@yahoo.co.uk


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Can anybody send me the linkk from where i can download sql server 2005
    free issue
    softprogrammer2003@yahoo.co.uk


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

    I am unable to download this
    (687-7925-library.sql) please send me this on my id: zeeshansabir@ymail.com

    Thanks in advance
    regards


    Post Feedback
    You must Sign In to post a feedback.
    Next Project: Training And Placement
    Previous Project: Simple Authentication and registration process for a website through Membership schema

    Return to Project Index

    Post New Project


    Related Projects


    Top Contributors
    Today
      Last 7 Daysmore...

      Awards & Gifts

      Online Members

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