Sorting, Searching, and Filtering

Summary

In this chapter, you looked at sorting, searching, and filtering over disconnected data. This is quite an important part of ADO.NET. A good handle on these concepts will allow you to write effective applications.

This chapter discussed the various methods of working with disconnected data using DataTables, DataViews, DataRelations, and, finally, using the XmlDataDocument. Typically, in an application built around disconnected architecture, you would query the data and fill a disconnected cache-such as a DataTable or a DataSet. Then, based upon the user’s requests, you would make updates to that data.

While this chapter presented you with the concepts of being able to find the right rows to make updates to, the next two chapters will discuss the process of making the updates and persisting them into a data source. What you have learned in this chapter will be very useful in the next chapter, which discusses updating data.