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
- How to enable Search Feature in Django admin?
- How to check PAN-Aadhaar is Linked or NOT?
- How to customize pagination for django admin?
- How to fix HAXM is not installed |in Android Studio
- How to fix CMOS Checksum Error in Computer or Laptop | SOLVED
- Reactivating windows after a Hardware change on PC or Laptop
- FIXED: Windows reported that the hardware of your device has changed. Error code :0xc004F211
- "redirect" is not defined pylance("reportUndefinedVariable)
Related Article