GetValues Method (MySqlDataReader)
Gets all column values for the current row.
|
|---|
'Declaration
Public Overrides Function GetValues( _
ByVal () As Object _
) As Integer |
Parameters
- values
- An array of System.Object into which to copy the attribute column values.
Return Value
The number of instances of
System.Object in the array.
The example shows how to retrieve several fields at once. Note that only the first three fields are retrieved, though there may be more in the table.
|
|---|
public void GetObjects(MySqlConnection mySqlConnection)
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test.Emp");
cmd.Connection = mySqlConnection;
mySqlConnection.Open();
try
{
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
object[] objs = new object[3];
int quant = reader.GetValues(objs);
for (int i=0;i < quant;i++)
{
Console.WriteLine(objs[i]);
}
reader.Close();
}
finally
{
mySqlConnection.Close();
}
} |
|
|---|
Public Sub GetObjects(ByVal mySqlConnection As MySqlConnection)
Dim cmd As MySqlCommand = New MySqlCommand("SELECT * FROM Test.Dept")
cmd.Connection = mySqlConnection
mySqlConnection.Open()
Try
Dim reader As MySqlDataReader = cmd.ExecuteReader()
reader.Read()
Dim objs(3) As Object
Dim quant As Integer = reader.GetValues(objs)
Dim i As Integer
For i = 0 To quant - 1
Console.WriteLine(objs(i))
Next i
reader.Close()
Finally
mySqlConnection.Close()
End Try
End Sub |