Bewerken

Share via


DataTableReader.Read Method

Definition

Advances the DataTableReader to the next record.

public:
 override bool Read();
public override bool Read ();
override this.Read : unit -> bool
Public Overrides Function Read () As Boolean

Returns

true if there was another row to read; otherwise false.

Exceptions

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

Examples

The PrintColumns procedure loops through all the rows in the DataTableReader, displaying the contents of each column in the Console window.

private static void PrintColumns(DataTableReader reader)
{
    // Loop through all the rows in the DataTableReader
    while (reader.Read())
    {
        for (int i = 0; i < reader.FieldCount; i++)
        {
            Console.Write("{0} ", reader[i]);
        }
        Console.WriteLine();
    }
}
Private Sub PrintColumns( _
   ByVal reader As DataTableReader)

   ' Loop through all the rows in the DataTableReader.
   While reader.Read()
       For i As Integer = 0 To reader.FieldCount - 1
         Console.Write("{0} ", reader(i))
      Next
      Console.WriteLine()
   End While
End Sub

Remarks

The default position of the DataTableReader is before the first record. Therefore, you must call Read to start accessing any data.

Applies to