1. ASP.NET DataSet is Designed for connected access.

2. Dataset is a data structure, which represents the complete table data at same
time.

3. Dataset is just a data store and manipulation is done through DataAdapters in
.NET.

4. DataSet can contain multiple tables

Retrieving data from more than one table or source does not require a JOIN.

5. XML, like HTML, is plaintext: “Firewall friendly"

About RecordSet:

1. ADO RecordSet is disconnected Architecture.

2. Recordset provides data one row at a time.

3. Recordset has the logic to update and manipulate data

4. The RecordSet is the central data container

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

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

5. Problems marshalling through firewalls (DCOM, binary)