Summary

In this chapter, we discussed both the DataTable and the DataView objects. We discussed how to add, edit, delete, and insert new rows into each. We illustrated how to derive multiple DataViews from the same DataTable and how to modify one DataView individually and manipulate specific rows of data while not affecting the others. We then showed you how to use the SqlCommandBuilder to automatically generate SqlCommands used to save changes back to your datasource. We ended the chapter with a large code example illustrating how to use all these objects together. Specifically, the chapter explored

• An introduction to the DataTable and DataView

• Working with the DataTable

• Working with the DataView

• Using the SqlCommandBuilder to save changes

• Bringing it all together