MySQL Select

Dim con1 As New MySqlConnection("server=localhost;Port=3307;user id=root;password=****;database=benchmark_database")
Dim sda1 As New MySqlDataAdapter("select * from class", con1)
Dim ds1 As New DataSet()
sda1.Fill(ds1)
My.Response.Write(ds1.Tables(0).Rows(0).Item(0))

dotConnect for MySQL

http://www.devart.com/dotconnect/mysql/download.html

MySQL ConnectionString

<add name="ConnectionString" connectionString="User Id=root;Password=****;Host=255.255.255.255;Port=3307;Database=benchmark_database;Persist Security Info=True;CharSet=utf8;" providerName="Devart.Data.MySql" />



ref http://www.connectionstrings.com/mysql