GetValues Method (SQLiteDataReader)

In This Topic

Syntax
Remarks
Example
See Also

Gets all column values for the current row.

Syntax

Visual Basic
C#

public override int GetValues( 
   object[] values
)

'Declaration
 
Public Overrides Function GetValues( _
   ByVal values() 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.

Remarks

For most applications, the GetValues method provides an efficient way for retrieving all column values, rather than retrieving each column value individually.

You can pass an System.Object array that contains fewer than the number of column values contained in the resulting row. Only the amount of data the System.Object array holds is copied to the array. You can also pass an System.Object array whose length is more than the number of columns contained in the resulting row.

This method returns System.DBNull for redundant array elements.

Example

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.

csharp

public void GetObjects(SQLiteConnection sqConnection)
{
  SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Emp");
  cmd.Connection = sqConnection;
  sqConnection.Open();
  try
  {
    SQLiteDataReader 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
  {
    sqConnection.Close();
  }
}

Visual Basic

Public Sub GetObjects(ByVal sqConnection As SQLiteConnection)
  Dim cmd As SQLiteCommand = New SQLiteCommand("SELECT * FROM Dept")
  cmd.Connection = sqConnection
  sqConnection.Open()
  Try
    Dim reader As SQLiteDataReader = 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
    sqConnection.Close()
  End Try
End Sub

Reference

SQLiteDataReader Class
SQLiteDataReader Members
GetValue Method

Send Feedback