connecte til MySql

du henter MySQL Connector for .NET her http://dev.mysql.com/downloads/connector/net/1.0.html

der er både dokumentation og eksempler

eksempel med DataReader:

Imports System
Imports System.Data
Imports MySql.Data.MySqlClient

Class MainClass
    Public Shared Sub Main(ByVal args As String())
        Dim con As MySqlConnection = New MySqlConnection ("Database=Test;Data Source=localhost;User Id=;Password=")
        con.Open
        Dim sel As MySqlCommand = New MySqlCommand ("SELECT * FROM T1", con)
        Dim rdr As MySqlDataReader = sel.ExecuteReader
        While rdr.Read
            Dim f1 As Integer = rdr(0)
            Dim f2 As String = rdr(1)
            Console.WriteLine(f1 & " " & f2)
        End While
        rdr.Close
        con.Close
    End Sub
End Class

Takker ligger du et svar

kommer her