Microsoft® .NET Compact Framework Kick Start

Filling a DataSet by Using the SqlCeDataAdapter

The Compact Framework also provides the ability to load data directly from SQL Server CE into a DataSet. This is done by using the SqlCeDataAdapter to fill the DataSet. The SqlCeDataAdapter can fill the DataSet and then update the underlying database with any changes. In other words, the DataSet can manage all communication between your application and the SQL Server CE database.

The SqlCeDataAdapter manages the underlying database by running four different commands against the database when synchronization is required. These four commands are exposed as properties on the SqlCeDataAdapter. They are the SelectCommand property, the InsertCommand property, the UpdateCommand property, and the DeleteCommand ...