VB.Net program to create a database in MySql dynamically

Here, we are going to learn how to create a database in MySql dynamically in VB.Net?
Submitted by Nidhi, on February 09, 2021 [Last updated : March 08, 2023]

Prerequisites: Need to install MySQL server and MySQL connector.

VB.Net – Create a MySQL Database

In this program, here we will connect to MySQL and create a specified database dynamically.

Program/Source Code:

The source code to create a database in MySql dynamically is given below. The given program is compiled and executed successfully.

VB.Net code to create a database in MySql dynamically

'VB.NET program to create a database in MySql dynamically.

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"

        Dim conn As New MySqlConnection(connString)

        conn.Open()

        Dim cmd As New MySqlCommand("create database sampledb", conn)
        cmd.ExecuteNonQuery()

        Console.WriteLine("Database sampledb created successfully")
        conn.Close()
    End Sub
End Module

Output

Database sampledb created successfully 
Press any key to continue . . .

Explanation

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's connectivity credentials. After that we established the connection to the MySql using MySqlConnection class and then create the "sampledb" database using ExecuteNonQuery() method of MySqlCommand class and print the "Database sampledb created successfully" message on the console screen.

VB.Net Database Connectivity Programs »





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.