ADVERTISEMENT
ADVERTISEMENT

VB.Net program to insert a record in the MySql database

Here, we are going to learn how to insert a record in the MySql database 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 then insert a record into the "employee" table.

Program/Source Code:

The source code to insert a record in the MySql database is given below. The given program is compiled and executed successfully.

'VB.NET program to insert a record in MySql database.

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 InsertCommand As String

        InsertCommand = "INSERT INTO employee(eid,ename, salary) VALUES(@eid,@ename,@salary)"

        Dim cmd = New MySqlCommand(InsertCommand, conn)

        cmd.Parameters.AddWithValue("@eid", 101)
        cmd.Parameters.AddWithValue("@ename", "Amit Kumar")
        cmd.Parameters.AddWithValue("@salary", 43200)
        cmd.Prepare()

        cmd.ExecuteNonQuery()
        Console.WriteLine("Record inserted successfully")
        conn.Close()
    End Sub
End Module

Output:

Record inserted 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 insert a record into the "employee" table using ExecuteNonQuery() method of MySqlCommand class and then print the "Record inserted 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.