Dataset vs Recordset

· A DataSet can represent an entire relational database in
   memory,complete with tables, relations, and views.
·  A DataSet is designed to work without any continuing
   connection to the original data source.
·  Data in a DataSet is bulk-loaded, rather than being loaded
   on demand.
·  There’s no concept of cursor types in a DataSet.
·  DataSets have no current record pointer You can use For Each
   loops to move through the data.
·  You can store many edits in a DataSet, and write them to the
   original data source in a single operation.
·  Though the DataSet is universal, other objects in ADO.NET come
   in different versions for different data sources.