Visual Basic 2013 Lesson 33: Working with Databases

[Lesson 32] << [Contents] >> [Lesson 34]

33.1 Introduction to Database

Every day we come across all types of information or data such as names, addresses, money, date, stock quotes, statistics and more. If you are in business or working as a professional, you have to handle even more data. For example, a doctor needs to keep track of patients’ information such as names, addresses, phone numbers as well as blood pressure readings, blood sugar readings, surgical history, medicines prescribed in the past and more. On the other hand, businesses usually have a large amount of data pertaining to products and customers. All these data need to be organized into a database. The database can then be used to perform MIS functions such as data mining and big data analytics.

In the past, people usually deal with data manually like using cards and folders. However, in present-day fast paced global environment and Information age, it is no longer feasible to manage data manually. Most data are now managed using computer-based database management systems. Computer-based Database management systems can handle data much faster and more efficient than human beings do. With the advent of the network and the Internet technologies, data can now be managed locally and remotely.Companies usually invest heavily in database management systems in order to run the organizations efficiently and effectively.


33.2 Creating a Database Application

A database management system typically deals with storing, modifying, and extracting information from a database. It can also add, edit and delete records from the database. However, a DBMS can be very difficult to handle by ordinary people or businessmen who have no technological backgrounds. Fortunately, we can create user-friendly database applications to handle the aforementioned jobs with the DBMS running in the background. One of the best programs that can create such database application is none other than Visual Basic 2013.

Visual Basic 2013 uses ADO.NET to handle databases. ADO.NET is Microsoft’s latest database technology which can work with many other advanced database management systems such as Microsoft SQL server. In this lesson, we will develop codes that make use of Microsoft SQL Server 2012, therefore you need to have Microsoft SQL Server 2012 installed in your PC,  you can download the free Microsoft SQL Server 2012 Express from

To begin building the database project in Visual Basic 2012, launch Visual Basic 2012. You can name your project as Database Project 1 or whatever name you wish to call it. Next, change the default form’s Text property to Contacts as we will be building a database of a contact list. There are a few objects in ADO.NET that are required to build the database. There are:

  • SqlConnection– to connect to a data source in SQL Server
  • DataTable -to store data for navigation and manipulation
  • DataAdapter– to populate a DataReader


vb2013_figure33.1Figure 33.1

Under imported namespaces, make sure, System.Data.Sqlclient is selected, otherwise, check them. Having done that you need to click the Save All button on the toolbar and then return to the Visual Basic 2013 IDE.

We shall proceed to create a connection to the database source file in the next lesson.
