SqlDataRecord.Item[] Property
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.
| Item[Int32] |
Gets the common language runtime (CLR) type value for the column specified by the column |
| Item[String] |
Gets the common language runtime (CLR) type value for the column specified by the column |
Gets the common language runtime (CLR) type value for the column specified by the column ordinal argument.
public:
virtual property System::Object ^ default[int] { System::Object ^ get(int ordinal); };public virtual object this[int ordinal] { get; }member this.Item(int) : objDefault Public Overridable ReadOnly Property Item(ordinal As Integer) As ObjectParameters
- ordinal
- Int32
The zero-based ordinal of the column.
Property Value
The CLR type value of the column specified by the ordinal.
Implements
Exceptions
The ordinal is less than 0 or greater than the number of columns (that is, FieldCount).
Remarks
For columns with null value, Value is returned.
Applies to
SqlClient .NET Core 5.2 and other versions
| Product | Versions |
|---|---|
| SqlClient .NET Core | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |
| SqlClient .NET Framework | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |
| SqlClient .NET Standard | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |
Gets the common language runtime (CLR) type value for the column specified by the column name argument.
public:
virtual property System::Object ^ default[System::String ^] { System::Object ^ get(System::String ^ name); };public virtual object this[string name] { get; }member this.Item(string) : objDefault Public Overridable ReadOnly Property Item(name As String) As ObjectParameters
- name
- String
The name of the column.
Property Value
The CLR type value of the column specified by the name.
Implements
Remarks
For columns with null value, Value is returned.
Applies to
SqlClient .NET Core 5.2 and other versions
| Product | Versions |
|---|---|
| SqlClient .NET Core | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |
| SqlClient .NET Framework | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |
| SqlClient .NET Standard | 1.0, 1.1, 2.0, 2.1, 3.0, 3.1, 4.0, 4.1, 5.0, 5.1, 5.2 |