1.Recordset provides data one row at a time.
Dataset is a data structure which represents the complete table data at same time.
2.Recordset has the logic to update and manipulate data.
Dataset is just a data store and manipulation is done through DataAdapters in .NET.
3.Dataset Disconnected architecture.
Record Set Connected Architecture.
4.With Data set you can retrive data from database like oracle and SQL Server and manage them in one dataset, with recordset this is not possible.
5. All representation of Dataset is using XML while recordset uses COM.
6. The Recordset was not XML-based and could not be serialized to XML easily or flexibly.
7. Recordset can not be transmitted on HTTP while Dataset can be.
8. A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
9. A DataSet is designed to work without any continuing connection to the original data source.
10. Data in a DataSet is bulk-loaded, rather than being loaded on demand.
11. There’s no concept of cursor types in a DataSet.
12. DataSets have no current record pointer You can use For Each loops to move through the data.
13. You can store many edits in a DataSet, and write them to the original data source in a single operation.
14. Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources
