Microsoft® .NET Compact Framework (Core Reference)
by Andy Wigley, Stephen Wheelwright, Robert Burbidge, Rory MacLoed, Mark Sutton
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access