Difference between an ADO.NET Dataset and an ADO Recordset

* A DataSet can represent an entire relational database in memory with tables, relations, and views.Recordset can not.
* A DataSet is designed to work without any connection to the original data source. Recordset maintains the continuous connection with the original data source.
* No concept of cursor types in a DataSet. They are bulk loaded while Recordset work with cursors and they are loaded on demand.
* DataSets have no current record pointer, you can use For Each loops to move through the data. Recordsets have pointers to move through them.
* You can store many edits in a DataSet, and write them to the original data source in a single operation. Recordset can have a single edit at a time.
* Dataset can fetch source data from many tables at a time whereas Recordset you can achieve the same only using the SQL joins.