| | Answer: - A DataSet is designed to work disconnected mode but ADO recordset is always work connected mode.
- There's no concept of cursor types in a DataSet but ADO RecordSet support to cursor types
- You can store many data version in a DataSet, and write them to the original data source in a single operation but ADO Recordset does support to more than one version
- DataSet can contain multiple tables but he RecordSet only one table
- RecordSet is Required More time than DataSet For data retrival
- DataSet is always better than the RecordSet compare for best performance.
- Dataset makes the relationship between the table that belongs in dataset.but there are no concepts like relations in ADO Recordset
- DataSet support to export many data formats such as XML, HTML and more but ADO Record set not.
- DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
| |