DataTableReader.Read Method

Reference

Definition

Namespace:: System.Data

Assembly:: System.Data.Common.dll

Assembly:: System.Data.dll

Assembly:: netstandard.dll

Source:: DataTableReader.cs

Source:: DataTableReader.cs

Source:: DataTableReader.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

Boolean

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

Exceptions

InvalidOperationException

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