dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteDataReader Class / FieldCount Property
Example

On this page
    FieldCount Property (SQLiteDataReader)
    On this page
    Gets the number of columns in the current row.
    Syntax
    'Declaration
     
    Public Overrides ReadOnly Property FieldCount As Integer
    public override int FieldCount {get;}

    Property Value

    When not positioned in a valid record set, 0; otherwise the number of columns in the current record. The default value is -1.
    Remarks
    After executing a query that does not return rows, FieldCount returns 0.
    Example
    This sample demonstrates how to iterate through fields in a row using FieldCount property.
    public void FetchResults(SQLiteConnection sqLiteConnection)
    {
      SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Dept");
      cmd.FetchSize = 100;
      cmd.Connection = sqLiteConnection;
      sqLiteConnection.Open();
      try
      {
        SQLiteDataReader reader = cmd.ExecuteReader();
        while (reader.Read())
        {
          for (int i=0;i<reader.FieldCount;i++)
          {
            Console.Write("\t"+reader[i]);
          }
          Console.WriteLine();
        }
      }
      finally
      {
        sqLiteConnection.Close();
      }
    }
    Public Sub FetchResults(ByVal sqLiteConnection As SQLiteConnection)
      Dim cmd As SQLiteCommand = New SQLiteCommand("SELECT * FROM Dept")
      cmd.FetchSize = 100
      cmd.Connection = sqLiteConnection
      sqLiteConnection.Open()
      Try
        Dim reader As SQLiteDataReader = cmd.ExecuteReader()
        While reader.Read()
          Dim i
          For i = 0 To reader.FieldCount - 1
            Console.Write(String.Concat(" ", reader(i)))
          Next i
          Console.WriteLine()
        End While
      Finally
        sqLiteConnection.Close()
      End Try
    End Sub
    See Also