Menampilkan Record ke Datagridview

Menampillkan Data Record Mysql Ke Datagridview Sourcode nya seperti berikut ini :

dim sql as string

dim dt as New DataTable

dim  dtadafter as mysqldataadafter

sql = “SELECT * FROM datamahasiswa;”
Try
dtadafter = New MySqlDataAdapter(sql, cls.koneksimysql)
dt.Clear()
dtadafter.Fill(dt)
DataGridView1.DataSource = dt
DataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect
dtadafter.Dispose()
cls.koneksimysql.Close()
Catch ex As Exception
MsgBox(“Gagal Tampil Data ” & ex.ToString)
cls.koneksimysql.Close()
End Try

 

Semoga Bermanfaat.