DataTableReader.Read Method ()

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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: