SqlDataReader::GetFieldValue<T> Method (Int32)
Synchronously gets the value of the specified column as a type. GetFieldValueAsync<T> is the asynchronous version of this method.
Assembly: System.Data (in System.Data.dll)
Parameters
- i
-
Type:
System::Int32
The column to be retrieved.
Return Value
Type: TThe returned type object.
Type Parameters
- T
The type of the value to be returned. See the remarks section for more information.
| Exception | Condition |
|---|---|
| InvalidOperationException | The connection drops or is closed during the data retrieval. The SqlDataReader is closed during the data retrieval. There is no data ready to be read (for example, the first Read hasn't been called, or returned false). Tried to read a previously-read column in sequential mode. There was an asynchronous operation in progress. This applies to all Get* methods when running in sequential mode, as they could be called while reading a stream. |
| IndexOutOfRangeException | Trying to read a column that does not exist. |
| SqlNullValueException | The value of the column was null (IsDBNull == true), retrieving a non-SQL type. |
| InvalidCastException | T doesn’t match the type returned by SQL Server or cannot be cast. |
T can be one of the following types:
Boolean | Byte | Char | DateTime |
DateTimeOffset | Decimal | Double | Float |
Guid | Int16 | Int32 | Int64 |
SqlBoolean | SqlByte | SqlDateTime | SqlDecimal |
SqlDouble | SqlGuid | SqlInt16 | SqlInt32 |
SqlInt64 | SqlMoney | SqlSingle | SqlString |
String | UDT, which can be any CLR type marked with SqlUserDefinedTypeAttribute. |
For more information, see SqlClient Streaming Support.
Available since 4.5