Answered Questions

  • Difference between data set and ADO Record set

    Star Read Best Answer

    Editorial / Best Answer


    • Member Since Nov-2006 | Aug 12th, 2007

    1) A DataSet can represent an entire relational database in memory, complete with tables, relations, and views, A Recordset can not.

    2) A DataSet is designed to work without any continuing connection to the original data source; Recordset maintains the contentious connection with the original data source.

    3) There's no concept of cursor types in a DataSet, They are bulk loaded, while Recordset work with cursors and they are loaded on demand.

    4) DataSets have no current record pointer, you can use For Each loops to move through the data. Recordsets have pointers to move through them.


    • Jan 24th, 2013

    Please need some more related information about the each topic..It is not sufficient to answer in Interviews.


    • Oct 29th, 2009

    To get the data from a database and put it on a data control In ADO they used recordset In ADO.Net they used dataset Record set is a connection oriented architecture whereas dataset supports a c...