O'Reilly logo

Microsoft® .NET Compact Framework (Core Reference) by Mark Sutton, Rory MacLoed, Robert Burbidge, Stephen Wheelwright, Andy Wigley

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

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

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