how to do the connection vb with mysql localhost

See more:

VB

MySQL

hai, anyone can help me. how do i connect this code with mysql localhost using wamp server and insert data in database. is this code should be written on each form to connect to the database or there is another solution to help.

(i write in login form)

Imports MySql.Data.MySqlClient
Public Class Form1
Dim conn As String = "Driver={MySQL};SERVER=localhost;DATABASE=mydb;"

Public Sub retriveData()
Try
Dim connection As New MySqlConnection(conn)
Dim cmd As New MySqlCommand

connection.Open()

Dim reader As MySqlDataReader
reader = cmd.ExecuteReader()

While reader.Read()
Console.WriteLine((reader.GetString(0) & ", " & _
reader.GetString(1)))
End While

reader.Close()
connection.Close()
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
End Sub
End Class