'Declaration Public Overrides ReadOnly Property RecordsAffected As Integer
public override int RecordsAffected {get;}
'Declaration Public Overrides ReadOnly Property RecordsAffected As Integer
public override int RecordsAffected {get;}
System.Data.Common.DbDataReader.IsClosed and RecordsAffected are the only properties that you can call after the SQLiteDataReader is closed.
public void ProcessReader (SQLiteDataReader sqReader) { if (!sqReader.IsClosed) { while (sqReader.Read()) { for (int i=0;i<sqReader.FieldCount;i++) { Console.Write("\t"+sqReader[i]); } Console.WriteLine(); } } else { Console.WriteLine("The DataReader is closed. Rows affected in last action: "+sqReader.RecordsAffected); } }
Public Sub ProcessReader(ByVal sqReader As SQLiteDataReader) If Not sqReader.IsClosed Then Dim i As Integer While sqReader.Read() For i = 0 To sqReader.FieldCount - 1 Console.Write(" " & sqReader(i)) Next i Console.WriteLine() End While Else Console.WriteLine("The DataReader is closed. Rows affected in last action: " & sqReader.RecordsAffected) End If End Sub