ADO.NET 2.0 Question:
Download Questions PDF

Explain the difference in Record set and Dataset?

Answer:

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.

Download ADO.NET 2.0 Interview Questions And Answers PDF

Previous QuestionNext Question
Explain the Differences between OLEDB SQL SERVER, OLEDBDOTNET PROVIDER?Explain all the classes those are used for database connections between sql server and asp.net?