Programming with ADOCE

The ADO for Windows CE control allows you to programmatically create and modify databases. The Recordset object of the ADOCE control is the cornerstone of ADOCE data access. Data is read and manipulated in a database through this object. The Field object consists of the fields of a recordset. A Field object should not be explicitly created because it exists only in the context of a Recordset object. The Fields collection contains a Field object for each column in a Recordset object.

For more information on programming the ADO for Windows CE control, see:

• Working with the Recordset object
  
  
• Creating a Table
  
  
• Storing and Retrieving Information in a Table
  
  
• Sorting a Table
  
  
• Listing all ADOCE Tables

Note   Before you can use the ADOCE control in Visual Basic, you need to create a reference to the control in the integrated development environment (IDE). The following procedure describes how to do this.

To use the ADO for Windows CE control in Visual Basic

1. Choose References from the Project menu
   
   
2. In the References dialog box, select the check box next to Microsoft CE ADO Control (ADOCE) 2.0.
   
   
3. Choose OK.