cara koneksi vb.net dengan database mysql menggunakan mysql.data.mysqlclient
Imports MySql.Data.MySqlClient
Public Class Form1
Dim conn As MySqlConnection
Dim da As MySqlDataAdapter
Dim ds As DataSet
Sub koneksi()
conn = New MySqlConnection("server=localhost;user=root;password=;database=absen")
conn.Open()
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
koneksi()
Me.CenterToScreen()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
On Error Resume Next
da = New MySqlDataAdapter("select * from karyawan", conn)
ds = New DataSet
da.Fill(ds)
dgv.DataSource = ds.Tables(0)
dgv.ReadOnly = True
End Sub
End Class