IsClosed Property (UniDataReader)
Gets a value indicating whether the data reader is closed.
The sample below reads all data from DataReader if it is not closed; otherwise it displays a message and some information.
|
|---|
public void ProcessReader (UniDataReader myReader)
{
if (!myReader.IsClosed)
{
while (myReader.Read())
{
for (int i=0;i<myReader.FieldCount;i++)
{
Console.Write("\t"+myReader[i]);
}
Console.WriteLine();
}
}
else
{
Console.WriteLine("The DataReader is closed. Rows affected in last action: "+myReader.RecordsAffected);
}
} |
|
|---|
Public Sub ProcessReader(ByVal myReader As UniDataReader)
If Not myReader.IsClosed Then
Dim i As Integer
While myReader.Read()
For i = 0 To myReader.FieldCount - 1
Console.Write(" " & myReader(i))
Next i
Console.WriteLine()
End While
Else
Console.WriteLine("The DataReader is closed. Rows affected in last action: " & myReader.RecordsAffected)
End If
End Sub |
