NOT : VB 6 ICIN, http://dev.mysql.com/tech-resources/...-handling.html


.net kullanacaksan ".net connector" kullanman lazim, tabi mysql icin konusuyorum mssql den anlamam pek..

ama ben .net connector da sorun yasadigim icin. .net framework ile gelen odbc connection kullaniyorum ama öncelikle mysql odbc 3.51 driverni yüklemen lazm... yükledikten sonra..


Imports System.Data.Odbc

Public MyConString As String = "DRIVER={MySQL ODBC 3.51 DRIVER};" & _
"SERVER=77.79.88.xx;" & _
"DATABASE=xx;" & _
"UID=xx;" & _
"PASSWORD=xx;" & _
"OPTION=3;"
Public MyConnection As New OdbcConnection(MyConString)
Public MyCommand As New OdbcCommand()

Public Sub MySQL_Baglan()
Try
MyConnection.Open()
Catch ex As OdbcException
Msgbox (ex.message)
End Try
End Sub



bu sadece baglanma isi

daha sonra

Public MyCommand As New OdbcCommand()
Public MyDataReader As OdbcDataReader

MyCommand.Connection = MyConnection
MyCommand.CommandText = "SELECT * FROM musteriler ORDER BY firma_adi ASC"
MyDataReader = MyCommand.ExecuteReader
While MyDataReader.Read
firmaisimleri.Add(MyDataReader("firma_adi"))
End While
MyDataReader.Close()
MyCommand.Dispose()

MyDataReader("firma_adi")) bu kisimda sütünun adi.firmaisimleri kismida bir comboboxdir tek veri cekiceksen textbox da kullanabilirsin, takildigin yer varsa sorabilirsin.