SqlDataReader.FieldCount Property

Reference

Definition

Namespace:: System.Data.SqlClient

Assembly:: System.Data.SqlClient.dll

Assembly:: System.Data.dll

Package:: System.Data.SqlClient v4.9.0

Source:: System.Data.SqlClient.notsupported.cs

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

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.

Applies to

Product	Versions
.NET	Core 1.0, Core 1.1, 6 (package-provided), 7 (package-provided), 8 (package-provided), 9 (package-provided), 10 (package-provided)
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0 (package-provided)

Share via