Public Sub ReadMyData(ByVal myConnString As String)
Dim magentoConnection As New MagentoConnection(myConnString)
Dim magentoCommand As MagentoCommand = magentoConnection.CreateCommand()
magentoCommand.CommandText = "SELECT customer_id, firstname, lastname FROM Customers"
magentoConnection.Open()
Dim magentoReader As MagentoDataReader = magentoCommand.ExecuteReader()
Try
' Always call Read before accessing data.
While magentoReader.Read()
Console.WriteLine(String.Concat(magentoReader.GetInt32(0).ToString(), " ", _
magentoReader.GetString(1), " ", magentoReader.GetString(2)))
End While
Finally
' always call Close when done reading.
magentoReader.Close()
' Close the connection when done with it.
magentoConnection.Close()
End Try
End Sub