ADO.NET 2.0 - What is difference in Record set and Dataset

GeekInterview.com > Interview Questions > Microsoft > ADO.NET 2.0

Next Question

ADO.NET 2.0 | Question 1 of 19

What is difference in Record set and Dataset

Recordset provides data one row at a time.

Dataset is a data structure which represents the complete table data at same time.

Recordset has the logic to update and manipulate data

Dataset is just a data store and manipulation is done through DataAdapters in .NET.

Total Answers and Comments: 12

Last Update: August 28, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: sibassp

A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
A DataSet is designed to work without any continuing connection to the original data source.
Data in a DataSet is bulk-loaded, rather than being loaded on demand.
There's no concept of cursor types in a DataSet.
DataSets have no current record pointer You can use For Each loops to move through the data.
You can store many edits in a DataSet, and write them to the original data source in a single operation.
Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.

Above answer was rated as good by the following members:
veluworld

Sorting Options

Page 1 of 2

« First

Last »

September 27, 2005 05:39:29

Sachin Kulshreshtha

RE: What is difference in Record set and Dataset

Data Reader worked as conventional Record Set of VB but Data Set Can store a complete database with all the relations and constraints.

Data Reader worked in Readonly where as Data Set provid u the flexibility of Updating data also.

Data Reader worked in connected mode only whereas Data set works in disconnected mode also.

Is this answer useful? Yes | No

October 05, 2005 05:15:06

Madhuri.ch

RE: What is difference in Record set and Dataset

Apart from wat sachin has said in a dataset is disconnected by default but in a recordset we need to set its feature to disconnected if needed as that property is not default

Is this answer useful? Yes | No

December 24, 2005 20:28:34

revathi_kalaivanan

Member Since: December 2005 Contribution: 2

RE: What is difference in Record set and Dataset

Dataset vs Recordset

1.collection of tables VS single table.

2.no need for join to use diff. DB tables VS need join.

Is this answer useful? Yes | No

April 12, 2006 02:07:21

deepak sai nair

RE: What is difference in Record set and Dataset

the main diff betwn recordset and dataset is recordset is created in the server side so that a connection should be established every time we work on recordset but in case of dataset it is created in the client side so that there is no need of any connection at the time of working on the dataset which makes the accessing faster.

Is this answer useful? Yes | No

June 19, 2006 07:24:23

Manju D J

What is difference in Record set and Dataset

***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).

***Dataset doesn't exist in ADO.

Is this answer useful? Yes | No

July 07, 2006 01:07:21

Madhu.Ch

RE: What is difference between Datagrid and Dataset

In datagrid we can do editable and in dataset shows data table shows once at a time but what is the main difference

Is this answer useful? Yes | No

October 30, 2006 05:31:28

vinita tyagi

RE: What is difference in Record set and Dataset

1. Record set is the part or object of connected Architecture means it needs full time connectivity with database while it is in working.and dataset needs not full time connectivity.it makes connection once and put all data in its cache memory and then no need of connection for doing operation (insert update delete ....).

2.Record set return single row at a time . while dataset return number of rows at a time.

Is this answer useful? Yes | No

March 17, 2007 04:53:36

Madhuri Chavan

RE: What is difference in Record set and Dataset

The main differences are:

>with dataset you can retrieve data from two databases like oracle &sql server & merge them in one dataset with recordset it is not possible.

>all representation of dataset is using XML while recordset uses COM

>Recordset cannot be transmitted on Http while dataset can be transmitted.

Is this answer useful? Yes | No

May 10, 2007 00:23:48

sibassp

RE: What is difference in Record set and Dataset

A DataSet can represent
an entire relational database in memory complete with tables relations and
views.

A DataSet is designed
to work without any continuing connection to the original data source.

Data in a DataSet is
bulk-loaded rather than being loaded on demand.

There's no concept of
cursor types in a DataSet.

DataSets have no
current record pointer You can use For Each loops to move through the data.

You can store many
edits in a DataSet and write them to the original data source in a single
operation.

Though the DataSet is
universal other objects in ADO.NET come in different versions for different
data sources.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 23, 2007 02:52:23

#10

Rajavel

RE: What is difference in Record set and Dataset

RecordSet: ->It requires the db connection throughout the process.
->It represents only very few records not the entire relational DB.
DataSet:-> It is connectionless ( We can get d data from DB and without depending on the connection we can work on it.

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank