Manipulating ADO Recordsets (Page 1 of 5 )
In previous tutorials we only looked at some of the recordset properties and methods. However, it's useful to stop and consider how we may put some of these already considered methods and properties to use. Some of the most important aspects of data retrieval concern how the data is going to be used and how it may be manipulated. We will be looking at these issues, building upon the previous tutorials.
You will find it beneficial to review the previous tutorials, which you can reach at the links shown below, with the most recent one listed first:
With the recordset open, we may want to manipulate the recordset rows to accomplish sorting, filtering and finding. Sorting refers to reordering the rows either in descending or ascending order in such a fashion that one or more of their columns (fields) gets rearranged (aka sorted). Filtering, on the other hand, involves using criteria such that only the record or records meeting the criteria are selected for display or other use. Finding is searching through the recordset to locate the rows, one of whose columns satisfies a certain criteria. Sort and Filter properties are dependent on the data provider.
For the purposes of this tutorial, a table named "Employees" has been imported into a Microsoft Access (MS Access 2003) application, manip.mdb. Some extra data (a couple of rows) has been added to the table to make the examples more useful. The table design is as shown in the next picture.
Next: Sorting the recordset >>
More Database Articles
More By Jayaram Krishnaswamy
