SqlDataReader.FieldCount Property


Gets the number of columns in the current row.

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public override int FieldCount { get; }

Property Value

Type: System.Int32

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

Exception Condition

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.

.NET Framework
Available since 1.1
Return to top