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.