In this articles describes how to use mysql connection in vb.net. Here I am using ADO.net to connect mysql with vb.net. Add mysql.data reference to the reference folder and use it in your form.
Imports MySql.Data.MySqlClient
Using cn As New MySqlConnection(“ConnectionString”)
cn.Open()
Dim cmd As MySqlCommand =cn.CreateCommand
With cmd
.CommandText = "storeprocedurename"
.CommandType = CommandType.StoredProcedure
.Parameters.AddWithValue("parameter1", parameter1)
.Parameters.AddWithValue("parameter2", parameter2)
.ExecuteNonQuery()
End With
cn.Close()
End Using
ConnectionString refers a connection string in your application.
Post your comments / questions
Recent Article
- Fix-Gradient effect turning to gray in after effects
- How to blur an image in python?
- ModuleNotFoundError: No module named 'whois' in Python GoviralHost Without Terminal
- How to Convert Image to Pencil Sketch in Python?
- AttributeError: module 'urllib' has no attribute 'request' - Python
- How to Extract audio from video files using python?
- PermissionError: [Errno 13] Permission denied: 'shampoo_sales.csv' - Python
- [WinError 145] The directory is not empty: 'FolderPath' - Python
Related Article