GeekInterview.com
Series: Subject: Topic:
Question: 24 of 58

Difference between ado.net data set and ADO Record set

Asked by: Interview Candidate | Asked on: Feb 15th, 2007

Editorial / Best Answer

Answered by: ramakrishnag1982

View all questions by ramakrishnag1982   View all answers by ramakrishnag1982

Member Since Nov-2006 | Answered On : 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 - 13 of 13 Answers
Amar

Answered On : 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

Yes  3 Users have rated as useful.
  
Login to rate this answer.
Rajeev Kumar

Answered On : 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

Yes  1 User has rated as useful.
  
Login to rate this answer.
Pawan Rai

Answered On : 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
 

Yes  1 User has rated as useful.
  
Login to rate this answer.
Sanjay Dobhal

Answered On : 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.

Yes  1 User has rated as useful.
  
Login to rate this answer.
subhrajyotsna

Answered On : Mar 23rd, 2007

View all answers by subhrajyotsna

Dataset follows disconnected architecture but recordset follows connected arcitecture.

Yes  1 User has rated as useful.
  
Login to rate this answer.

Recordset is like a sigle dimentional array where a set of rows are stored.
Dataset is like a Muti Dimentional Array where different sets of rows can be stored

  
Login to rate this answer.
sahu

Answered On : Mar 29th, 2007

View all questions by sahu   View all answers by sahu

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

  
Login to rate this answer.

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.

Yes  4 Users have rated as useful.
  
Login to rate this answer.
kann27

Answered On : Aug 7th, 2008

View all answers by kann27

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.

  
Login to rate this answer.

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)

Yes  1 User has rated as useful.
  
Login to rate this answer.
arun_sarafmca

Answered On : May 20th, 2009

View all answers by arun_sarafmca

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.

  
Login to rate this answer.
sathin

Answered On : Oct 29th, 2009

View all answers by sathin

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.


  
Login to rate this answer.
Kishore

Answered On : Jan 24th, 2013

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

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.