Gets position of the record that will be read next from the current result in data reader.
public int CurrentRecord {get;}
'Declaration
Public ReadOnly Property CurrentRecord As Integer
Property Value
Position of the record that will be read next from the current result in data reader.
In the following code
CurrentRecord property is used to identify output strings.
public void FetchThemAll(MySqlConnection myConnection)
{
MySqlCommand cmd = new MySqlCommand("SELECT EmpNo, EName FROM Test.Emp");
cmd.FetchAll = true;
cmd.Connection = myConnection;
myConnection.Open();
try
{
MySqlDataReader reader = cmd.ExecuteReader();
foreach (IDataRecord rec in reader)
{
Console.Write(reader.CurrentRecord);
Console.Write("\t"+rec["EmpNo"]);
Console.WriteLine("\t"+rec["EName"]);
}
}
finally
{
myConnection.Close();
}
}
Public Sub FetchThemAll(ByVal myConnection As MySqlConnection)
Dim cmd As MySqlCommand = New MySqlCommand("SELECT EmpNo, EName FROM Test.Emp")
cmd.FetchAll = True
cmd.Connection = myConnection
myConnection.Open()
Try
Dim reader As MySqlDataReader = cmd.ExecuteReader()
For Each rec As IDataRecord In reader
Console.Write(reader.CurrentRecord)
Console.Write(String.Concat(" ", rec("EmpNo")))
Console.WriteLine(String.Concat(" ", rec("EName")))
Next
Finally
myConnection.Close()
End Try
End Sub
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2