DataTableReader.Item Property (Int32)

 

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

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

Public Overrides ReadOnly Property Item (
	ordinal As Integer
) As Object

Parameters

ordinal
Type: System.Int32

The zero-based column ordinal.

Property Value

Type: System.Object

The value of the specified column in its native format.

Exception Condition
IndexOutOfRangeException

The index passed was outside the range of 0 to FieldCount - 1.

This overload for Item behaves identically to the GetValue method.

The following example displays the contents of all the columns, in all the rows from the supplied DataTableReader. The code uses the Item method (the indexer, in Microsoft C#) to retrieve the value that is contained in each column.

Private Sub DisplayItems(ByVal reader As DataTableReader)
   Dim rowNumber As Integer
   While reader.Read()
      Console.WriteLine("Row " & rowNumber)
      For i As Integer = 0 To reader.FieldCount - 1
         Console.WriteLine("{0}: {1}", reader.GetName(i), reader.Item(i))
      Next
      rowNumber += 1
   End While
End Sub

.NET Framework
Available since 2.0
Return to top
Show: