Chapter 6. Consuming and Manipulating Data

Terms you'll need to understand:

• System.IO namespace

• System.Xml namespace

• Transact-Structured Query Language (T-SQL)

• SELECT statement

• INSERT statement

• UPDATE statement

• DELETE statement

• Ad-hoc query

• FileStream class

• DataAdapter class

• DataView class

Techniques you'll need to master:

• Understanding the difference between ad-hoc queries and stored procedures

• Knowing how to construct basic SQL statements using the T-SQL dialect supported by Microsoft SQL Server

• Understanding how to use the DataSet object to make data available within your application

• Using the Framework Class Library to view a DataSet as XML

Now that you know how to bind controls to the data model, you should develop an understanding of the basics involved in manipulating and consuming (using) data from a variety of sources. This chapter focuses on accessing data located in external disk files, relational databases, and XML files as well as provides a brief review of SQL Server operation and the handling of data errors.