⟩ Explain the difference in Record set and Dataset?
Data Reader worked as conventional Record Set of VB but Data Set Can store a complete database with all the relations and constraints.
Data Reader worked in Read only where as Data Set provide u the flexibility of Updating data also.
Data Reader worked in connected mode only, whereas Data set works in disconnected mode also.
Recordset is a collection of records returned by the query.
Dataset is merely a collection of tables.