Gets or sets the number of the current result in data reader.
public int CurrentResult {get; set;}
'Declaration
Public Property CurrentResult As Integer
Property Value
The number of the current result in data reader.
This sample shows how to iterate through results returned by a multiple query.
public void FetchResults(MySqlConnection myConnection)
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test.Dept;SELECT * FROM Test.Emp");
cmd.FetchAll = true;
cmd.Connection = myConnection;
myConnection.Open();
try
{
MySqlDataReader reader = cmd.ExecuteReader();
for (int cRes = 0; cRes < reader.ResultCount; cRes++)
{
reader.CurrentResult = cRes;
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
Console.Write("\t" + reader[i]);
}
Console.WriteLine();
}
}
}
finally
{
myConnection.Close();
}
}
Public Sub FetchResults(ByVal myConnection As MySqlConnection)
Dim cmd As MySqlCommand = New MySqlCommand("SELECT * FROM Test.Dept;SELECT * FROM Test.Emp")
cmd.FetchAll = True
cmd.Connection = myConnection
myConnection.Open()
Try
Dim reader As MySqlDataReader = cmd.ExecuteReader()
Dim cRes As Integer
For cRes = 0 To reader.ResultCount - 1
reader.CurrentResult = cRes
While reader.Read()
Dim i As Integer
For i = 0 To reader.FieldCount - 1
Console.Write(String.Concat(" ", reader(i)))
Next i
Console.WriteLine()
End While
Next cRes
Finally
myConnection.Close()
End Try
End Sub