ADO.NET

difference between recordset and dataset

answer to dataset vs recordset

Recordset provides data one row at a time.

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

Recordset has the logic to update and manipulate data

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

dataset is disconnected by default but in a recordset we need to set its feature to disconnected if needed as that property is not default