Koneksi MySql dengan Visual Basic DatagridView
barsa — Sat, 04/18/2009 - 20:11
Contoh koneksi ke Mysql DataBase dan menampilkan satu tabel ke DataGridView Visual Basic.
Contoh koneksi ke Mysql DataBase dan menampilkan satu tabel ke DataGridView Visual Basic. Dim cmd As New MySql.Data.MySqlClient.MySqlCommand Dim connect As New MySql.Data.MySqlClient.MySqlConnection("Database=test;Data Source=localhost;User Id=root") cmd.CommandText = "SELECT * FROM `satu`" Dim Datanya As New DataTable da.Fill(Datanya) DataGridView1.DataSource = Datanya
cmd.Connection = connect
Dim da As New MySqlDataAdapter(cmd.commandtext, connect)
Dim cb As New MySqlCommandBuilder(da)


