Extending MFC Applications with the .NET Framework

Searching, Sorting, and Filtering Data

So far, you've learned how to connect to a data store, retrieve the desired data, close the connection, modify the data locally (including adding, editing, and deleting records), and then update the data store at will—once again only holding the connection long enough to synchronize your in-memory representation of the data with the data store. As you'll discover in this section, the ADO.NET classes also support the ability to search, sort, and filter data once it's been retrieved. In fact, being able to perform these operations against your disconnected data without making continual round trips to the server is one of the strongest arguments for using disconnected data to begin with.

We'll begin by looking ...