O'Reilly logo

Windows® CE 3.0 Application Programming by Marshall Brain, Nick Grattan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required