Chapter 4. Accessing the Right Data Values

After completing this chapter, you will be able to:

  • Find items in a DataTable by primary key

  • Search for DataRow instances using standard query statements

  • Obtain a set of DataRow objects sorted by one or more columns

  • Add expression columns to a DataTable that present calculated values

Although adding records to a DataTable is important, the real value of ADO.NET lies in getting those records back out in a variety of ways. Fortunately, the data framework includes many different methods and tools to fulfill that very purpose.

This chapter introduces a few of the most basic tools, all of which appear in the DataTable, DataColumn, and DataRow classes you’ve already met. Each data table includes features that let ...

Get Microsoft® ADO.NET 4 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.