So far, this chapter has concentrated on getting data from SQL Server onto the smart device using some of the objects in the System.Data.SqlClient namespace. Once data is retrieved, the .NET Compact Framework application can make changes to the data and then update the data source. This chapter will look at two different update techniques:
Updating bound data
Updating by executing a stored procedure
You will see how to use a stored procedure to update SQL Server data directly in the section "Using SQL Server Stored Procedures" later in this chapter; let’s start now by looking at how to update the database with changes made in a DataTable by bound controls.
When a DataTable object is bound to controls that allow editing ...