langsung saja berikut scriptnya :
Imports MySql.Data.MySqlClient
Module Module1
Public Database As New MySqlConnection
Public Tampil As New MySql.Data.MySqlClient.MySqlCommand
Public Tampilkan As MySql.Data.MySqlClient.MySqlDataReader
Public Grid As New MySql.Data.MySqlClient.MySqlDataAdapter
Public Ds As New DataSet
Public Tabel As String
Public record As New BindingSource
Public Sub Koneksi()
Try
Database.Close()
Database.ConnectionString = "server=localhost;" _
& "user id=root;" _
& "password=;" _
& "database=surat"
Database.Open()
Catch ex As Exception
MsgBox(ex.ToString())
End Try
End Sub
End Module
---------------------------------------------------------------------------------------------------------
Note : "surat" adalah nama database yang saya buat pada database mysql
Terima Kasih sudah berkunjung ke Blog saya :)
https://bit.ly/2xOwfcz