CurrentRecord Property

In This Topic

Gets position of the record that will be read next from the current result in data reader.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property CurrentRecord As Integer

public int CurrentRecord {get;}

Property Value

Position of the record that will be read next from the current result in data reader.

Remarks

A value of CurrentRecord increases by 1 after advancing to the next record by using the Read method. You can position MySqlDataReader to any record using the Seek method.

You can use CurrentRecord property in condition that MySqlDataReader is retrieved while FetchAll property is set to true.

Example

In the following code CurrentRecord property is used to identify output strings.

csharp

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();
  }
}

Visual Basic

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

Reference

MySqlDataReader Class
MySqlDataReader Members
FetchAll Property

Send Feedback