Datasets vs RecordSetsEssentially it is to do with how it fetches the data and allows you to intereact with it, recordsets would typically only allow you to fetch data from one table at a time (with default settings) whereas datatables can retrieve the entire set of data. there is more information at that linkDataset is a connectionless data holder whereas RecordSet is connection oriented Data holder.Though DataSet you can refer more than 1 table at a time, but in the case of Recordset only 1 table is processed at a time. Through Dataset you can process more than 1 record,but in case of recordset recordset you have to make travesel to each record and after that you can make processing.
Dataset is a connectionless data holder whereas RecordSet is connection oriented Data holder.when Dataset has read write option the recoerdset has only read option
• 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 onnection 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.