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.

subhrajyotsna

 Profile Answers by subhrajyotsna 

• Mar 23rd, 2007

 

Dataset follows disconnected architecture but recordset follows connected arcitecture.

avkdsiva

 Profile Answers by avkdsiva Questions by avkdsiva

• Mar 26th, 2007

 

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

sahu

 Profile Answers by sahu Questions by sahu

• Mar 29th, 2007

 

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

ramakrishnag1982

 Profile Answers by ramakrishnag1982 Questions by ramakrishnag1982

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

kann27

 Profile Answers by 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.

vijay kumar meena

 Profile Answers by vijay kumar meena 

• Aug 29th, 2008

 

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)

arun_sarafmca

 Profile Answers by arun_sarafmca 

• May 20th, 2009

 

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.

sathin

 Profile Answers by 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.

Kishore

• Jan 24th, 2013

 

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