There are two methods for accessing a record's column properties.


Access the columns on the record object:


EmployeesRecordset rs = new EmployeesRecordset();

rs.Load(5);

EmployeesRecord record = rs[0];

string firstname = record.FirstName;

string lastname = record.LastName;


The second method is using the column properties on the resultset. A resultset has the same column properties as the record.


The column properties on the resultset are linked to the Currently Selected Record.


The current record can be set with Resultset.CurrentRecord and Resultset.CurrentRecordIndex properties. Full information is available in the Currently Selected Record topic.


EmployeesRecordset rs = new EmployeesRecordset();

rs.Load(5);

string firstname = rs.FirstName;

string lastname = rs.LastName;