Loading

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

Submitted by: 
Visitors have accessed this post 78235 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




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

maganda yan

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

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

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

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

admin's picture

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

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]

murad's picture

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

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

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's picture

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

  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

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

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

Please provide me the username & password.Thanks

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

good

good

good

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

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

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

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.

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

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

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.

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

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

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

 As soon as possible if possible
Thanks

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

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 :)

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

sir
please give me user name and password

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

abdiqani.a.warsame's picture

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

pls send the codes

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

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

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

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

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • 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.