Reads a forward-only stream of rows from MySQL.
The following example creates a
MySqlConnection, a
MySqlCommand, and a
MySqlDataReader. The example reads through the data, writing it out to the console. Finally, the example closes the
MySqlDataReader, then the
MySqlConnection.
|
|---|
public void ReadMyData(string myConnString) {
MySqlConnection mySqlConnection = new MySqlConnection(myConnString);
MySqlCommand mySqlCommand = (MySqlCommand)mySqlConnection.CreateCommand();
mySqlCommand.CommandText = "SELECT DeptNo, DName, Loc FROM Test.Dept";
mySqlConnection.Open();
MySqlDataReader mySqlReader = mySqlCommand.ExecuteReader();
try {
// Always call Read before accessing data.
while (mySqlReader.Read()) {
Console.WriteLine(mySqlReader.GetInt32(0).ToString() + " " +
mySqlReader.GetString(1) + " " + mySqlReader.GetString(2));
}
}
finally {
// always call Close when done reading.
mySqlReader.Close();
// Close the connection when done with it.
mySqlConnection.Close();
}
} |
|
|---|
Public Sub ReadMyData(ByVal myConnString As String)
Dim mySqlConnection As New MySqlConnection(myConnString)
Dim mySqlCommand As MySqlCommand = mySqlConnection.CreateCommand()
mySqlCommand.CommandText = "SELECT DeptNo, DName, Loc FROM Test.Dept"
mySqlConnection.Open()
Dim mySqlReader As MySqlDataReader = mySqlCommand.ExecuteReader()
Try
' Always call Read before accessing data.
While mySqlReader.Read()
Console.WriteLine(String.Concat(mySqlReader.GetInt32(0).ToString(), " ", _
mySqlReader.GetString(1), " ", mySqlReader.GetString(2)))
End While
Finally
' always call Close when done reading.
mySqlReader.Close()
' Close the connection when done with it.
mySqlConnection.Close()
End Try
End Sub |