Difference between ado.net data set and ADO Record set

Editorial / Best Answer

ramakrishnag1982  

  • 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.

Showing Answers 1 - 39 of 39 Answers

Amar

  • Feb 21st, 2007
 

1. .net DataSet is Disconnected architecture while ADO Recordset is Connected.
2. We can easily return datarecords using DataSet but as far as i know it is not possible with recordset

Rajeev Kumar

  • Feb 22nd, 2007
 

It is a wrong answer. Data set store multiple table from database while recordset only one table at time.Dataset store date as xml formate

Pawan Rai

  • Mar 8th, 2007
 

As far as i have studies i know that ADO(Active Data Objects) has several problems associated like unwieldness of disconnected record set. So ado.net overcome this problem and gives best support fro disconnected environment useing dataset
 

Sanjay Dobhal

  • Mar 16th, 2007
 

Dataset works on disconnected mode and can hold multiple table at one time but recordset works on connected mode and can hold one table at one time.

Hi All,



Ans:

a. DataSet is Disconnected architecture while ADO Recordset is Connected.
b. Dataset  catch bluk Data where   recordSet retrive one record one at time

  Was this answer useful?  Yes

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.

kann27

  • Aug 7th, 2008
 

Dataset Disconnected architecture
Dataset can view full table or partion of table view the particular column.
Dataset can be connect two database example Oracle, SQL.
Record Set Connected Architecture.

  Was this answer useful?  Yes

About DataSet

1. ASP.NET DataSet is Designed for connected access.
2. Dataset is a data structure, which represents the complete table data at same
time.
3. Dataset is just a data store and manipulation is done through DataAdapters in
.NET.
4. DataSet can contain multiple tables
Retrieving data from more than one table or source does not require a JOIN.
5. XML, like HTML, is plaintext: “Firewall friendly"


About RecordSet:


1. ADO RecordSet is disconnected Architecture.
2. Recordset provides data one row at a time.
3. Recordset has the logic to update and manipulate data
4. The RecordSet is the central data container
RecordSet is one (1) table that contains all the data
Retrieving data from more than one table or source requires a database JOIN.
5. Problems marshalling through firewalls (DCOM, binary)

1. Dataset is Disconnected Architecture While ADO Recordset is Connected
Architecture.
2. Dataset Store Multiple Tables while Data Recordset is only one table at a
time.

  Was this answer useful?  Yes

sathin

  • 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 connection-less architecture.
In ADO using recordset the connection is of open database connection.
Open database connections, use system resources to a maximum extent
making the system performance less effective.
By keeping connections open for a minimum period of time, ADO.NET
conserves system resources and provides maximum security for databases
and also has less impact on system performance


The number of tables in a record set is one whereas in a dataset can
be any number.


  Was this answer useful?  Yes

Kishore

  • Jan 24th, 2013
 

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions