VB.Net program to get the Mysql version using the ‘Select’ statement
'VB.NET program to get MySql version
using Select statement.Imports MySql.Data.MySqlClient
Module Module1
Sub Main()Dim connString AsStringDim MySqlVersion AsString'Connection String to connect with MySQL database.
connString ="server=localhost;userid=root;password=root;database=sampledb"Dim conn AsNew MySqlConnection(connString)
conn.Open()Dim cmd AsNew MySqlCommand("Select VERSION()", conn)
MySqlVersion = cmd.ExecuteScalar().ToString()
Console.WriteLine("MySql Version is: "& MySqlVersion)
conn.Close()EndSubEndModule
MySql Version is: 8.0.22
Press any key to continue . . .