DataSet

If you’ve done any database programming using previous versions of ADO, you are probably familiar with the Recordset object. A Recordset object represents the results of a query returned by the database. Its properties and methods let you move through the returned data record-by-record, examining and modifying individual fields, and inserting and deleting records. In ADO, the Recordset provides a program’s main point of interaction with the database. You can perform some operations using other objects, such as using the Connection object to execute SQL statements to create and drop tables, but programs use the Recordset to fetch large amounts of data.

In ADO.NET, the DataSet object is positioned to be the program’s main access to the ...

Get Visual Basic® .NET Database Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.