- A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
- A DataSet is designed to work without any continuing connection to the original data source.
- Data in a DataSet is bulk-loaded, rather than being loaded on demand.
- There's no concept of cursor types in a DataSet.
- DataSets have no current record pointer You can use For Each loops to move through the data.
- You can store many edits in a DataSet, and write them to the original data source in a single operation.
- Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.
Difference between an ADO.NET Dataset and an ADO Recordset
ADO Recordset,
ADO.Net,
ADO.NET Dataset,
DataSet,
Recordset
ADO.NET Dataset & ADO Recordset Feature:
Hot on Web:
