ADO.NET 2.0 Question:
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.
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.
| Previous Question | Next 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? |