uday

• Aug 11th, 2005

 

DataSet is a ADO.Net object and RecordSet is a ADO object

Praveen Kumar

• Sep 23rd, 2005

 

DataSet can be considered as a logical database as it has the capability to store more than one table and have relations maintained between the tables as in a relational database. Where as a RecordSet can hold only one table at a time.

saroj

• Sep 27th, 2005

 

dataset is based on disconnected architecture where as recordset is based on connected architecture.dataset is type safe where as record is not.dataset can contain different tables fron different database whereas recordset cannot.

Shal

 Profile Answers by Shal 

• Nov 4th, 2005

 

• Data set represents realtional database which can contains tables, constraints while recordset represents only one table.
• Dataset is disconnected state of database. While recordset is connected state of database
• In dataset there is no concept of cursortypes and lock type mechanism while in recordset these are main concepts.