ADVERTISEMENT
ADVERTISEMENT

VB.Net program to drop a table from the MySql database dynamically

Here, we are going to learn how to drop a table from the MySql database dynamically 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 drop a specified table from the database.

Program/Source Code:

The source code to drop a table from the MySql database dynamically is given below. The given program is compiled and executed successfully.

'VB.NET program to drop a table in 
'MySql database 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;database=sampledb"

        Dim conn As New MySqlConnection(connString)

        conn.Open()

        Dim cmd As New MySqlCommand("DROP TABLE IF EXISTS employee", conn)
        cmd.ExecuteNonQuery()

        Console.WriteLine("Table employee dropped successfully")
        conn.Close()
    End Sub
End Module

Output:

Table employee dropped 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 connectivity credentials. After that we established the connection to the MySql database using MySqlConnection class and then drop the "employee" table in the database using ExecuteNonQuery() method of MySqlCommand class and print the "Table employee dropped successfully" message on the console screen.

VB.Net Database Connectivity Programs »



ADVERTISEMENT


ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT

ADVERTISEMENT

ADVERTISEMENT

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

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

© https://www.includehelp.com some rights reserved.