What is the difference between Dataset and Recordset?

Below is the differences between Dataset and Recordset?

• Dataset is a disconnected architecture

• Dataset can be connect two database example oracle,sql table

• DataSet is Xml Based and faster

• Performancewise DataSet is better than recordset

• Data Set is main for storage tool in ADO.Net

• A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.

• 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.

• Recordset provides data one row at a time.

• Record Set is a Connected Architecture

• Recordset connect only one database

• RecordSet is one (1) table that contains all the data

• Retrieving data from more than one table or source requires a database JOIN.