Microsoft® .NET Compact Framework (Core Reference)

Summary

In this chapter, you have seen how to use the objects in the System.Data.SqlClient namespace to retrieve and update data. You have used the SqlConnection object to make a connection to a remote SQL Server from a smart device application, and you have used the SqlDataReader and SqlDataAdapter objects to retrieve data. You have seen how a SqlDataAdapter object can be used to retrieve data for a DataSet object, which can then use data binding to display values and retrieve changes in user interface controls. For both data retrieval and update, this chapter covered using SQL text and a stored procedure in a SqlCommand object, with its parameters represented by SqlParameter objects.

This chapter has also discussed the use of transactions with ...