Windows® CE 3.0 Application Programming

Adding Records to a Table

So far in this chapter ADOXCE interfaces have been used to manage tables in a database. Now, ADOCE interfaces will be used to manipulate data in tables. Data is most often manipulated using recordsets, which are object models that represent an extraction of data from tables. They can also be used to add new records to tables. First, we will look at a simple case of adding new data to a table.

First, a recordset must be created and then associated with a connection to the database the recordset will be opened on. For example, the following code fragment creates an instance of a Recordset, creates a VARIANT with the connection string, and then opens the recordset on the "Customers" table. The ProgID for the recordset specifies ...