One of the coolest features of Visual Studio .NET is the ability to bind a database into Windows Forms easily using DataSet. Since VB 6.0, I’m waiting for this kind of feature to be implemented in VB.NET. I am used with MS Access before and seem that VB.NET and MS Access has no difference when it comes to DataBinding.
There are many ways to bind your data. You can use the old fashion which is hard-coding, but this is out the scope of this tutorial. Why use hard-coding if you can do it easily using drag and drop operation?
In order to create an application in Visual Basic .NET like Payroll System, Accounting System, Enrollment System, Calculator, Point of Sale System, and Library System you need to create a project called “Windows Application”.
If you are new to programming and want to learn Visual Basic, you will probably confuse with so many option to choose in starting a Visual Basic Editor.
Please look at the screen below.
Actually i saw a question at the forum:
Create a program that will accept a sentence and count the number of vowels, consonants and determine the length of the sentence. The space is included. see the link!
Sometimes you want to transfer or backup your database in SQL Server. When the database is attached you cannot copy/move it to any location. All you have to do is detach it first using SQL Server Management Tools.
Another reason why I write this tutorial is to teach you so that when we finish the Library System project you will be able to switch from my own database to your own database just in case you want to differentiate each of the table.
1. Open SQL Server Management Tools.
2. Right click Database and click Attach.
