Library System in Visual Basic .NET 2008 and SQL Server 2008

Submitted by: 
admin
Language: 
Visual Basic .NET
Visitors have accessed this post 98031 times.

Here’s the full source code of the sample project, Visual Basic .NET 2008 Tutorial, I created this in addition with the tutorial that I've made several months ago.

It is advised that you will follow the tutorial closely to understand how I created this project.

There’s nothing so much information about this project for certainly, this project is not intended for advance programmer, thus it is being created for beginners, to show the method on how to program with Visual Basic .NET 2008 and using SQL Server as the database.

This tutorial will continue until the sample library system project is complete.

Account information:
Username: admin
Password: admin

Here’s the to do list:

Borrowed Books
Returned Books
Sample reports like Borrowed Books, Returned Books, Fine, Members Report, and a lot more.

You need to change the connection string of this project to use your own SQL Server instance name and computer name. For more info please visit:

How to Change Connection String of VB.NET Project at Design Time

Tags: 
vb.net
library system
admin's picture

Article by admin

admin has submitted 558 source code / articles.

If you like this post, you can follow SourceCodester on Twitter.

Subscribe to SourceCodester feed via RSS or EMAIL to receive instant updates.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

zanna bulama (not verified)

Mon, 09/15/2014 - 18:07

sir would you help me to send me source code for library management system in HTML and dbase to this Email [email protected]

palchen (not verified)

Wed, 04/23/2014 - 12:06

cn u send me the project source code At [email protected]

hello good day (not verified)

Tue, 02/04/2014 - 10:03

can u pls send me the full code of the system? heres my email [email protected] thanks a lot

chailyn25 (not verified)

Sun, 01/12/2014 - 14:31

can you send me the full code of this system please....i really need it....here's my email add. [email protected] :)

udhaya kumar (not verified)

Thu, 01/02/2014 - 14:02

pls send the codes

abdiqani.a.warsame

Tue, 09/10/2013 - 00:22

guys i need how to make crystal report that has 2 date parameter like in sales when the user want to know exmole from start date to end date plsssss

Marites Canilao (not verified)

Fri, 09/06/2013 - 13:54

can u send me the full system.thank u so much! this is my email [email protected]

elango (not verified)

Sat, 07/20/2013 - 22:24

sir
please give me user name and password

Anonymous (not verified)

Sat, 04/20/2013 - 05:08

Thank you...
baba damet gaaaaaaaaaarm... :)

Anonymous (not verified)

Sat, 02/09/2013 - 14:02

i just want to know why the icon of all the files inside this Library System is Dreamweaver and not Visual Basic ?
i really need this now ..
thanks :)
God'Speed :)

Anonymous (not verified)

Sat, 09/29/2012 - 03:47

I will very glad if the source code and the tutorial for this project to be made available to me through my mail address provided.

Thank you

Anonymous (not verified)

Sat, 09/29/2012 - 01:56

Is estimated that send me needy project library project complete with codes and designs vb.net

 As soon as possible if possible
Thanks

kings091

Thu, 09/13/2012 - 22:03

do you have a sample of sales and inventory system using VB.net 2008 and SQL server 2005.. nid help pls..
email me [email protected]

Go Programmers

naix (not verified)

Thu, 07/26/2012 - 02:49

how can i figure it out ? im just a beginner, please help out
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Microsoft Visual Studio Solution File, Format Version 10.00 # Visual Studio 200' at line 1

CharlesDeGall (not verified)

Thu, 06/28/2012 - 01:58

So... isnt the idea of borrowing and returning, to have it taken out of one when it's updated in the other dataset? I mean, you have a grid that shows borrowed books, and shouldnt returning them pull them out of that so they dont still show as borrowed???

Anybody can toss up a couple of grids that enter data.

nightOFday (not verified)

Sat, 06/23/2012 - 15:49

can you plss send the finish code of this system to my e-mail [email protected] ...thank you

plssss (not verified)

Mon, 06/18/2012 - 05:22

can you plss send the finish code of this system to my e-mail [email protected] ...thank you

M_joy (not verified)

Tue, 02/14/2012 - 09:27

Please help me Mr. admin
Hi! Good day, i have a project in Payroll System using VB 2008.can you please help me to do that? this is very important and my graduation based on that project. for my thesis project. Because that was the title that my prof gave to me. And as a requirements, we need it in VB 2008.please sir..i will appreciate so much if you send that detailed payroll system.send to this email.([email protected]).thank you in advance..God Bless.

M_joy (not verified)

Tue, 02/14/2012 - 09:19

send to this [email protected]
thanks in advance.i really need that info.

Pamela (not verified)

Sun, 02/12/2012 - 19:06

plz give me a source code of this system? here my email [email protected] tnx

Arnold Soliven (not verified)

Mon, 01/30/2012 - 11:11

Sir Can you please send me your Username and Password please i need it....thank you so much sir....God Bless

adilcom

Fri, 01/20/2012 - 11:42

good

adilcom

Fri, 01/20/2012 - 11:40

good

adilcom

Fri, 01/20/2012 - 11:36

good

Anonymous (not verified)

Tue, 11/08/2011 - 16:44

can you tell me how can you do for save the SQL server 2008 from vb.net 2008

Anonymous (not verified)

Fri, 11/04/2011 - 14:00

Please provide me the username & password.Thanks

Anonymous (not verified)

Sat, 09/17/2011 - 20:06

Hi! Good day, i found out that you have a Library System using VB 2008 and SQL 2008 posted in the internet. I downloaded the zip code. but it is not working, it won't extract..

Your system is perfect for my thesis project. Because that was the title that my prof gave to me. And as a requirements, we need it in VB 2008 and SQL 2008.

So pls, send me on this email: [email protected] your source code! Pls. I'm begging you. I really need it very badly.

I hope your sincere consideration. Pls send it to me! I'll be happy if your going to give me the source code. THANK YOU VERY MUCH. I'll be waiting for your reply!!! :D

dars (not verified)

Wed, 02/04/2015 - 19:35

how to create the log in button ?

Anonymous (not verified)

Tue, 10/11/2011 - 00:25

you must change your system because i don't know yet the codes so study hard okay!!!

Anonymous (not verified)

Wed, 07/13/2011 - 13:52

how to prompt user to save data if they close the form without saving ?
but if there is no changes been made, the user will not be prompt to save data when they click close..

admin

Wed, 07/13/2011 - 15:43

If you are using a databound form use the following code:

  1. Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
  2.      If DataSetName.HasChanges Then
  3.           'Statement here
  4.      End If
  5. End Sub

Anonymous (not verified)

Tue, 11/08/2011 - 16:47

can you explain step by step how can save the sql 2008 from vb.net 2008 then how to connect the vb.net in the sql 2008

Anonymous (not verified)

Sun, 03/18/2012 - 04:06 

  1. public ctrl as string
  2.  
  3.  
  4. imports system.data.sqlclient
  5.  
  6. public sqlcmd as new sqlcommand
  7. public sqlstrl as string 
  8. public sqlcon as new sqlconnection
  9. public sqlda as new sqldataadapter
  10. public sqldr as new sqldatareader
  11. sub connect()
  12. sqlcon.state = connectionstate.open then sqlcon.close
  13. sqlcon.connectionstring = "data source ".\sqlexpress; integrated security = true; attachdbfilename = |data directory|\practice.mdf; user instance = true"
  14. sqlcon open ()
  15. end sub

Anonymous (not verified)

Tue, 06/14/2011 - 17:46

please send me the username and password to [email protected]

murad

Wed, 05/11/2011 - 13:26

Good day sir

I am trying to develop a similar project depend on (loan and return) transact the problem is
I get confused in the middle
For example
(1-if the books quantity was 8 and i borrow 5 so the books quantity should be updated to 3.
2-when i return the borrowed books i supposed to choose from the borrowed list.
3- If i return 3 of these borrowed books or even it’s all the borrowed books quantity (qty borrwed) in (borrow) table should be updated and the books quantity as well.
4- If some of the get books damaged in proses the related tables should be updated. )
How can i managed all that and still have a historical list of the entire borrowed and returned list for reports?
Please your help is needed
Ps: i learn a lot from the database that you include in this project
I am still beginner in the whole programming so please when you explain it try to make it as simple as you can.
Thank you very much in advance

Anonymous (not verified)

Thu, 03/17/2011 - 18:35

i am in need of this project now having trouble connecting to sql pls help me ....can u send me the complete details on how to connect!!!!
whats the user name and pass...
mail it to [email protected]

Anonymous (not verified)

Thu, 03/03/2011 - 15:12

giving an error 26 - Error Locating Server/Instance Specified.....

sorry because im only a beginner can't figure it out.........

help me please...........

admin

Thu, 03/03/2011 - 16:22

Please follow this instruction:

http://www.sourcecodester.com/Tutorials/how-change-connection-string-vbn...

Anonymous (not verified)

Mon, 06/27/2011 - 15:56

how to run dis..where is the project file

Anonymous (not verified)

Sat, 02/26/2011 - 11:38

can you please finish the system i need this on march 1......thank you

Anonymous (not verified)

Tue, 02/22/2011 - 21:39

maganda yan

Add new comment

More information about text formats

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.