O'Reilly logo

Microsoft® .NET Compact Framework Kick Start by Ronnie Yates, Erik Rubin

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

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

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