Explain the difference in Record set and Dataset?

Submitted by: Administrator
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.
Submitted by: Administrator

Read Online ADO.NET 2.0 Job Interview Questions And Answers