encontrar registros

[eter_6]

disculpa no miré que era para MySQL, bueno aquí está en MySQL también ;)


Dim conn As New MySql.Data.MySqlClient.MySqlConnection
Dim myConnString As String
Dim myCommand As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim myData As New DataTable

myConnString = ConfigurationManager.ConnectionStrings("Demo").Con nectionString

conn.ConnectionString = myConnString

Try
conn.Open()
Catch myerror As MySqlException
MsgBox("Error al conectar a la Base de Datos: " & myerror.Message)
End Try

myCommand.Connection = conn
myCommand.CommandText = QUERY <---- aquí tu query

myAdapter.SelectCommand = myCommand
myAdapter.Fill(myData)

'y accedes igual

myData.Rows(0).Item(0)