Chapter 7. Consuming and Manipulating Data

Terms you'll need to understand:

• Concurrency control

• Dataset

• DOM (Document Object Model)

• Extensible Markup Language (XML)

• Namespace

• Schema

Techniques you'll need to master:

• Accessing and manipulating data from a Microsoft SQL Server database by creating and using ad hoc queries and stored procedures

• Knowing how to work with a dataset object

• Knowing how to read and write XML data using the classes from the System.Xml namespace

• Knowing how to handle database- related errors in your code

• Practicing reading and writing file-based data with the FileStream, StreamReader , and StreamWriter objects

In this chapter, you learn how to access and manipulate data in relational databases such as Microsoft SQL Server, data in XML format, and the data stored in disk files.