Library Management System

[attachment=17024]

1. INTRODUCTION
1.1 What Is Library Management system?
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 have 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

1.2 Purpose Of Library Management:
The Library management system will allow a proper computerized management of the library.
This type of management will minimize mismanagement and will enhance the answerabilty of the employees working in the college.

2. LITERATURE SURVEY

2.1 Advantages of VB:

Visual Basic .NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of Microsoft's Visual Basic (VB) which is generally implemented on the Microsoft .NET
Framework. Microsoft currently supplies Visual Basic Express Edition free of charge. Contents

1 Versions of Visual Basic .NET
1.1 Visual Basic .NET (VB 7)
1.2 Visual Basic .NET 2003 (VB 7.1)
1.3 Visual Basic 2005 (VB 8.0)
1.3.1 'IsNot' operator patented
1.3.2 Visual Basic 2005 Express
1.4 Visual Basic 2008 (VB 9.0)
1.5 Visual Basic 2010 (VB 10.0)
2 Relation to older versions of Visual Basic (VB6 and previous)