Read Method

DataTableReader.Read Method ()

 

Advances the DataTableReader to the next record.

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

public override bool Read()

Return Value

Type: System.Boolean

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

Exception Condition
InvalidOperationException

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

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

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();
    }
}

.NET Framework
Available since 2.0
Return to top
Show:
© 2016 Microsoft