Item Property (String)
Collapse the table of content
Expand the table of content

DataTableReader.Item Property (String)


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

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

Public Overrides ReadOnly Property Item (
	name As String
) As Object


Type: System.String

The name of the column.

Property Value

Type: System.Object

The value of the specified column in its native format.

Exception Condition

The name specified is not a valid column name.


An attempt was made to retrieve data from a deleted row.


An attempt was made to read or access a column in a closed DataTableReader.

A case-sensitive lookup is performed first. If it fails, a second case-insensitive search is made.

This method is kana-width insensitive.

This overloaded version of M:System.Data.DataTableReader.Item corresponds to calling the M:System.Data.DataTableReader.GetOrdinal method, and then subsequently calling the GetValue method.

Given a DataTableReader and a column name, the GetValueByName procedure returns the value of the specified column. Before calling this procedure, you must create a new DataTableReader instance and call its Read method at least one time to position the row pointer on a row of data.

Private Function GetValueByName( _
   ByVal reader As DataTableReader, _
   ByVal columnName As String) As Object

   ' Consider when to use a procedure like this one carefully:
   ' If you're going to retrieve information from a column
   ' in a loop, it would be better to retrieve the column
   ' ordinal once, store the value, and use the methods
   ' of the DataTableReader class directly. 
   ' Use Item(columnName) sparingly.
   Dim columnValue As Object

      columnValue = reader.Item(columnName)
   Catch ex As ArgumentException
      ' Throw all other errors back out to the caller.
      columnValue = Nothing
   End Try
   Return columnValue
End Function

.NET Framework
Available since 2.0
Return to top
© 2015 Microsoft