Edit

Share via

SqlDataReader.Item[] Property

  • Reference

Definition

Namespace:
System.Data.SqlClient
Assembly:
System.Data.SqlClient.dll
Assembly:
System.Data.dll
Assemblies:
netstandard.dll, System.Data.SqlClient.dll
Package:
System.Data.SqlClient v4.8.6

Gets the value of a column in its native format.

Overloads

Item[Int32]

Gets the value of the specified column in its native format given the column ordinal.
Item[String]

Gets the value of the specified column in its native format given the column name.

Item[Int32]

Gets the value of the specified column in its native format given the column ordinal.

public:
 virtual property System::Object ^ default[int] { System::Object ^ get(int i); };
public:
 property System::Object ^ default[int] { System::Object ^ get(int i); };
public override object this[int i] { get; }
public object this[int i] { get; }
member this.Item(int) : obj
Default Public Overrides ReadOnly Property Item(i As Integer) As Object
Default Public ReadOnly Property Item(i As Integer) As Object

Parameters

i
Int32

The zero-based column ordinal.

Property Value

Object

The value of the specified column in its native format.

Implements

Item[Int32]

Exceptions

IndexOutOfRangeException

The index passed was outside the range of 0 through FieldCount.

See also

Applies to

Item[String]

Gets the value of the specified column in its native format given the column name.

public:
 virtual property System::Object ^ default[System::String ^] { System::Object ^ get(System::String ^ name); };
public:
 property System::Object ^ default[System::String ^] { System::Object ^ get(System::String ^ name); };
public override object this[string name] { get; }
public object this[string name] { get; }
member this.Item(string) : obj
Default Public Overrides ReadOnly Property Item(name As String) As Object
Default Public ReadOnly Property Item(name As String) As Object

Parameters

name
String

The column name.

Property Value

Object

The value of the specified column in its native format.

Implements

Item[String]

Exceptions

IndexOutOfRangeException

No column with the specified name was found.

Remarks

A case-sensitive lookup is performed first. If it fails, a second case-insensitive search is made (a case-insensitive comparison is done using the database collation). Unexpected results can occur when comparisons are affected by culture-specific casing rules. For example, in Turkish, the following example yields the wrong results because the file system in Turkish does not use linguistic casing rules for the letter 'i' in "file".

This method is kana-width insensitive.

See also

Applies to