Windows apps
Collapse the table of content
Expand the table of content
Information
Switch
Switch
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

SqlDataReader::FieldCount Property

.NET Framework (current version)
 

Gets the number of columns in the current row.

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

C#
C++
F#
VB
Copy 
public:
property int FieldCount {
	virtual int get() override;
}

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.

Implements

IDataRecord::FieldCount IDataRecord::FieldCount

Exception Condition
NotSupportedException

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
Show:
© 2017 Microsoft