Summary

The DataSet is the key element of data manipulation inside client applications. It is important to keep in mind that when performing simple tasks, such as populating a grid like in the previous example, you need to consume as few client resources as possible. Avoid using a complex component like the DataSet in this case and simply go for a DataTable. There are instances, of course, when you would want to bind the grid to a DataSet because you would want the user to edit the data and save it back to the data source. You are now advised to read Chapter 8, “Migrating ADO Applications,” which provides you several scenarios of common data manipulation tasks.