Mastering Microsoft® Visual Basic® 2008

Chapter 24. Advanced DataSet Operations

As you know very well by now, DataSets are miniature databases that reside in the client computer's memory. They're made up of tables related to one another, they enforce relations, and they're practically as close to a client-side database as you can get without installing an actual database management system at every client. However, you can't execute SQL statements directly against the DataSet's data. You can't update a DataTable by issuing an UPDATE statement, and can't add rows with an INSERT statement. You know how to iterate through the rows of a DataTable and how to locate its related rows in other tables, and how to select rows from a DataTable with the Select method. You can iterate through the ...