SqlDataReader.FieldCount Property


Gets the number of columns in the current row.

 property int FieldCount { int get(); };
public int FieldCount { get; }
member this.FieldCount : int
Public ReadOnly Property FieldCount As Integer

Property Value

When not positioned in a valid recordset, 0; otherwise the number of columns in the current row. The default is -1.



There is no current connection to an instance of SQL Server.


Executing a query that, by its nature, does not return rows (such as a DELETE query), sets FieldCount to 0. However. this should not be confused with a query that returns 0 rows (such as SELECT * FROM table WHERE 1 = 2) in which case FieldCount returns the number of columns in the table, including hidden fields. Use VisibleFieldCount to exclude hidden fields.

Applies to

See also