Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLite - .NET Programming » UltraLite .NET 2.0 API Reference » ULDataReader class » Item properties


Item(String) property

Returns the value of the specified named column in its native format. In C#, this property is the indexer for the ULDataReader class.

Visual Basic

Public Overrides Default Readonly Property Item ( _
   ByVal name As String _
) As Object

public override object this [ 
   string  name
]  { get;}
  • name¬†¬† The name of the column.

Property value

The column value as the .NET type most appropriate for the column or DBNull if column is NULL.


Note that in result sets, not all columns have names and not all column names are unique. If you are not using aliases, the name of a non-computed column is prefixed with the name of the table the column is from. For example, MyTable.ID is the name of the only column in the result set for the query "SELECT ID FROM MyTable".

When accessing columns multiple times, it is more efficient to access columns by column ID than by name.

This method is equivalent to:

dataReader.GetValue( dataReader.GetOrdinal( name ) )
See also