Microsoft® .NET Compact Framework (Core Reference)

Updating Data

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.

Updating Bound Data

When a DataTable object is bound to controls that allow editing ...