SqlDataReader.FieldCount Property

Definition

Namespace:

Microsoft.Data.SqlClient

Assembly:

Microsoft.Data.SqlClient.dll

Package:

Microsoft.Data.SqlClient v5.2.0

Gets the number of columns in the current row.

public:
 virtual property int FieldCount { int get(); };

public override int FieldCount { get; }

member this.FieldCount : int

Public Overrides ReadOnly Property FieldCount As Integer

Property Value

Int32

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

Implements

FieldCount

Exceptions

NotSupportedException

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.