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

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

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

Submitted byAnonymous (not verified)on Tue, 02/22/2011 - 21:39

maganda yan
Submitted byAnonymous (not verified)on Sat, 02/26/2011 - 11:38

can you please finish the system i need this on march 1......thank you
Submitted byAnonymous (not verified)on 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...........

Please follow this instruction: http://www.sourcecodester.com/Tutorials/how-change-connection-string-vbnet-project-design-time.html

how to run dis..where is the project file
Submitted byAnonymous (not verified)on 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]
Submitted bymuradon 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
Submitted byAnonymous (not verified)on 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..

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

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
Submitted byAnonymous (not verified)on Sun, 03/18/2012 - 04:06

In reply to by Anonymous (not verified)

  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
Submitted byAnonymous (not verified)on 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
Submitted byAnonymous (not verified)on Tue, 10/11/2011 - 00:25

In reply to by Anonymous (not verified)

you must change your system because i don't know yet the codes so study hard okay!!!
Submitted bydars (not verified)on Wed, 02/04/2015 - 19:35

In reply to by Anonymous (not verified)

how to create the log in button ?
Submitted byAnonymous (not verified)on Tue, 11/08/2011 - 16:44

can you tell me how can you do for save the SQL server 2008 from vb.net 2008
Submitted byArnold Soliven (not verified)on 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
Submitted byPamela (not verified)on Sun, 02/12/2012 - 19:06

plz give me a source code of this system? here my email [email protected] tnx
Submitted byM_joy (not verified)on 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.
Submitted byplssss (not verified)on Mon, 06/18/2012 - 05:22

can you plss send the finish code of this system to my e-mail [email protected] ...thank you
Submitted bynightOFday (not verified)on Sat, 06/23/2012 - 15:49

can you plss send the finish code of this system to my e-mail [email protected] ...thank you
Submitted byCharlesDeGall (not verified)on 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.
Submitted bykings091on 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]
Submitted byAnonymous (not verified)on 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
Submitted byAnonymous (not verified)on 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 :)
Submitted byAnonymous (not verified)on Sat, 04/20/2013 - 05:08

Thank you... baba damet gaaaaaaaaaarm... :)
Submitted byelango (not verified)on Sat, 07/20/2013 - 22:24

sir please give me user name and password

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
Submitted byhello good day (not verified)on 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
Submitted byzanna bulama (not verified)on 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]

Add new comment