MySqlDataReader Class

Public NotInheritable Class MySqlDataReader
	Inherits DbDataReader
	Implements IDisposable, IDataReader, IDataRecord

public ref class MySqlDataReader sealed : public DbDataReader, 
	IDisposable, IDataReader, IDataRecord

[<SealedAttribute>]
type MySqlDataReader =  
    class
        inherit DbDataReader
        interface IDisposable
        interface IDataReader
        interface IDataRecord
    end

Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT OrderID, CustomerID FROM Orders"
Dim myConnection As New MySqlConnection(myConnString)
Dim myCommand As New MySqlCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myReader As MySqlDataReader
myReader = myCommand.ExecuteReader()
' Always call Read before accessing data.
While myReader.Read()
Console.WriteLine((myReader.GetInt32(0) & ", " & myReader.GetString(1)))
End While
' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
myConnection.Close()
End Sub 'ReadMyData

No code example is currently available or this language may not be supported.

No code example is currently available or this language may not be supported.