DataTableReader.Item[] 属性

Source:

DataTableReader.cs

Source:

DataTableReader.cs

Source:

DataTableReader.cs

public:
 virtual property System::Object ^ default[int] { System::Object ^ get(int ordinal); };

public override object this[int ordinal] { get; }

member this.Item(int) : obj

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

参数

属性值

以本机格式表示的指定列的值。

例外

示例

以下示例显示提供 的所有行 DataTableReader中的所有列的内容。 代码使用 Item[] Microsoft C#) 中索引器 (方法检索每列中包含的值。

private static void DisplayItems(DataTableReader reader)
{
    int rowNumber = 0;
    while (reader.Read())
    {
        Console.WriteLine("Row " + rowNumber);
        for (int i = 0; i < reader.FieldCount; i++)
        {
            Console.WriteLine("{0}: {1}", reader.GetName(i), reader[i]);
        }
        rowNumber++;
    }
}

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

注解

的 Item[] 此重载的行为与 方法相同 GetValue 。

另请参阅

• GetValue(Int32)

Source:

DataTableReader.cs

Source:

DataTableReader.cs

Source:

DataTableReader.cs

public:
 virtual property System::Object ^ default[System::String ^] { System::Object ^ get(System::String ^ name); };

public override object this[string name] { get; }

member this.Item(string) : obj

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

参数

属性值

以本机格式表示的指定列的值。

例外

示例

DataTableReader给定 和列名，GetValueByName 过程将返回指定列的值。 在调用此过程之前，必须创建新 DataTableReader 实例并调用其 Read 方法至少一次，以便将行指针置于数据行上。

private static object GetValueByName(
    DataTableReader reader, string columnName)
{
    // 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 this string-based indexer sparingly.
    object columnValue = null;

    try
    {
        columnValue = reader[columnName];
    }
    catch (ArgumentException ex)
    {
        // Throw all other errors back out to the caller.
        columnValue = null;
    }
    return columnValue;
}

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

   Try
      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

注解

首先执行区分大小写的查找。 如果失败，将进行第二次不区分大小写的搜索。

此方法不区分假名宽度。

的此重载版本 Item[] 对应于调用 GetOrdinal 方法，然后随后调用 GetValue 方法。