'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;}
The value of this property is not cumulative. For example, if two records are inserted in the first statement in batch mode, and the second statement affected 3 records, the value of RecordsAffected will be 3.
System.Data.Common.DbDataReader.IsClosed and RecordsAffected are the only properties that you can call after the MySqlDataReader is closed.
public void ProcessReader (MySqlDataReader 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 MySqlDataReader) 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