Diff Between Data Set and Record Set

[hariharanmca]

Can any1 explain the Diff Between Data Set and Record Set in detail

[kenobewan]

The ADO Recordset object is used to hold a set of records from a database table. A Recordset object consist of records and columns (fields). However,
ADO.NET does not have this object and many use the datareader instead.

The DataSet object is similar to the ADO Recordset object, but more powerful, and with one other important distinction: the DataSet is always disconnected. The DataSet object represents a cache of data, with database-like structures such as tables, columns, relationships, and constraints.

Hope that this helps.

[hariharanmca]

The ADO Recordset object is used to hold a set of records from a database table. A Recordset object consist of records and columns (fields). However,
ADO.NET does not have this object and many use the datareader instead.

The DataSet object is similar to the ADO Recordset object, but more powerful, and with one other important distinction: the DataSet is always disconnected. The DataSet object represents a cache of data, with database-like structures such as tables, columns, relationships, and constraints.

Hope that this helps.

which will be more faster

[kenobewan]

Here is an article that puts this to the test:
ASP.NET DATASET vs. ASP RECORDSET
and the winner is recordset by a long neck, but I'm sure that you had already guessed that ;).