SqlDataReader.FieldCount Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets the number of columns in the current row.
public:
virtual property int FieldCount { int get(); };
public:
property int FieldCount { int get(); };
public override int FieldCount { get; }
public int FieldCount { get; }
member this.FieldCount : int
Public Overrides ReadOnly Property FieldCount As Integer
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.
Implements
Exceptions
There is no current connection to an instance of SQL Server.
Remarks
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.