Comparision between recordset and dataset?

Comparision between recordset and dataset?

RecordSet is used in VB 6.0 and DataSet in VB.NET

RecordSet is operate in Connection Oriented Manner i.e. For Each Query and Each Record The Request goes to the database and after that user will get result.

• In RecordSet we can use only one database for Data operations.

DataSet:

DataSet is operate in Disconnected Manner i.e unlike the Recordset we don't Need to send query for each record instead of it Dataset can retrive all the information at a time so it operates in disconnected manner and we can use more that one database for data retriving using dataset.

So..........

• RecordSet is Required More time than DataSet For data retrival
• DataSet is always Better than the RecordSet.