ADOCE Info
The preferred mode of accessing relational data under Windows CE is via the ADOCE control. To make use of this control, I checked the Microsoft CE ADO Control 3.1 box in the References dialog box after selecting the Project, References menu item. Visual Basic developers will be familiar with this process. Adding a reference essentially imports a COM library into your project so that it can be used by the application. By adding a reference to the ADO control, we now have access to a number of objects, including Connection, Recordset, Field, and Errors. As you might imagine, the Connection object is used to build a connection to the database. A Recordset is used both to execute a query and to store the result set that's returned as a result of the query. Field objects represent individual data elements on a database record, and errors are, well, errors.