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 myConnection)
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test.Emp");
cmd.Connection = myConnection;
myConnection.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
{
myConnection.Close();
}
}
Public Sub GetObjects(ByVal myConnection As MySqlConnection)
Dim cmd As MySqlCommand = New MySqlCommand("SELECT * FROM Test.Dept")
cmd.Connection = myConnection
myConnection.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
myConnection.Close()
End Try
End Sub
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2