Chapter 11. Editing and Filtering Data

only for RuBoard

IN THIS CHAPTER

• The DataTable Versus DataView

• The DataTable: Filtering, Adding, Editing, Sorting, and Deleting DataRows

• The DataView: Filtering, Adding, Editing, Sorting, and Deleting DataRowViews

• Using the SqlCommandBuilder to Save Changes Back to Your Database

• Bringing It Together

• Summary

In this chapter, we will be discussing some of the ways you can work with data once it has been retrieved from your data store and put into a DataSet . Specifically, we will be going over the objects that make up a DataSet and how you can use these objects to filter, edit, delete, and add new items (rows). After going through each of the DataTable and DataView s individual properties and methods you can use to manipulate their prospective DataRowCollection ” rows that make up a DataTable , we'll discuss ways to save these changes back to your database. Finally, in the "Bringing It All Together" section, we'll provide a rather lengthy example that brings everything in the chapter together. Specifically, we will be covering the following topics in this chapter.

• An introduction to the DataTable and DataView

• Working with the DataTable

• Working with the DataView

• Using the SqlCommandBuilder to save changes back to your database

• Bringing it all together

In the first part of the chapter we briefly discuss the DataTable and DataView objects and what they are. The second section covers manipulating data in the DataTable , and the third section looks at the DataView and how to use it to create customized views of the data in DataTable s. We are going to end the chapter by illustrating an easy way to save changes made to a DataTable back to your database.

only for RuBoard