вот код с моей формы( нужно бы мне окно дабы открывалось и в нем я бы выбирал таблицу для загрузки в dataGridview) бд на локалхосте denwer phpmyadmin

Imports System
Imports System.Data
Imports System.Windows.Forms
Imports MySql.Data.MySqlClient


Public Class Form1



Dim conn As MySqlConnection
Dim reader As MySqlDataReader
Dim data As DataTable
Dim da As MySqlDataAdapter
Dim cd As MySqlCommandBuilder






Private Sub DataGridView1_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick

End Sub

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
If Not conn Is Nothing Then conn.Close() ' если есть подключ то закрываем
Try
Dim strconn As String = "server=localhost; user id=root; password=; database=dbtest; pooling=false;"
conn = New MySqlConnection(strconn)
conn.Open()
data = New DataTable

da = New MySqlDataAdapter("SELECT * FROM otmetki", conn)
cd = New MySqlCommandBuilder(da)

da.Fill(data)

DataGridView1.DataSource = data
Catch ex As Exception
MsgBox(ex.Message, vbExclamation, "Error")
End Try

End Sub
Private Sub Unload() Handles Me.FormClosed
If Not conn Is Nothing Then conn.Close()
End Sub

Private Sub Button1_Click(sender As Object, e As EventArgs)
Try
Dim changes As DataTable = data.GetChanges()
da.Update(changes)
data.AcceptChanges()
Catch ex As Exception
MsgBox(ex.Message, vbExclamation, "Error")
End Try
End Sub