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
- It is impossible to add a non nullable field without specifying a default. Django error
- ImportError: cannot import name 'url' from 'django.conf.urls' - Django Error
- How to Enable Virtualization in BIOS Security Settings in Intel Processors For Android Studio?
- Dependency 'androidx.activity:activity:1.8.0' requires libraries and applications that depend on it.
- AttributeError: 'NoneType' object has no attribute 'get_text' - Python
- ModuleNotFoundError: No module named 'openpyxl' - Python
- How to get thumbnail from vimeo video URL in Python?
- Remove all special characters, punctuation except spaces from string - Python
Related Article