VB.Net program to get the records of a specified MySql database table

Here, we are going to learn how to get the records of a specified MySql database table in VB.Net?
Submitted by Nidhi, on February 09, 2021

Prerequisites: Need to install MySQL server and MySQL connector.

In this program, here we will connect to the MySQL database and get "employee" records of the employee table then print them on the console screen.

Program/Source Code:

The source code to get the records of a specified MySql database table is given below. The given program is compiled and executed successfully.

'VB.NET program to get the records of a 
'specified MySql database table

Imports MySql.Data.MySqlClient

Module Module1
    Sub Main()
        Dim connString As String

        'Connection String to connect with MySQL database.
        connString = "server=localhost;userid=root;password=root;database=sampledb"

        Dim conn As New MySqlConnection(connString)

        Dim query = "SELECT * FROM employee"

        Dim cmd As New MySqlCommand(query, conn)
        Dim reader As MySqlDataReader

        reader = cmd.ExecuteReader()

        While (reader.Read())
            Console.WriteLine(reader.GetInt32(0) & " " & reader.GetString(1) & " " & reader.GetUInt32(2))
        End While

    End Sub
End Module


101 Amit Kumar 43200
102 Vikas 20000
Press any key to continue . . .


In the above program, we imported a namespace MySql.Data.MySqlClient to establish the connection with the MySql database. Then we created a module Module1 that contains a Main() function.

The Main() function is the entry point for the program. In the Main() function, we created a connection string variable ConnString that contains the database connectivity credentials. After that, we established the connection to the MySql database using MySqlConnection class and then get the employee records using MySqlDataReader class. Here, we used Read() method to record one by one and we used GetInt32(), GetString() methods to read column values and print records on the console screen.

VB.Net Database Connectivity Programs »



Comments and Discussions



Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© some rights reserved.