Sachin Kulshreshtha

• Sep 27th, 2005

 

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.

Madhuri.ch

• Oct 5th, 2005

 

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

revathi_kalaivanan

 Profile Answers by revathi_kalaivanan 

• Dec 24th, 2005

 

Dataset   vs  Recordset

1.collection of tables VS single table.

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

deepak sai nair

• Apr 12th, 2006

 

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.

Manju D J

• Jun 19th, 2006

 

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

 

 

Madhu.Ch

• Jul 7th, 2006

 

Hi

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

vinita tyagi

• Oct 30th, 2006

 

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.

 

Madhuri Chavan

• Mar 17th, 2007

 

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.

sibassp

• May 10th, 2007

 

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

Rajavel

• May 23rd, 2007

 

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.

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.

5) You can store many edits in a DataSet, and write them to the original data source in a single operation. Recordset can have a single edit at a time.

6) Dataset can fetch source data from many tables at a time, for Recordset you can achieve the same only using the SQL joins

veluworld

 Profile Answers by veluworld Questions by veluworld

• Aug 28th, 2008

 

Recordset is the Read only & forward only mechanism. But Dataset is the Editable. Recordset is connection oriented and Dataset need connection once to dump the data from the data base. Dataset holds more than one table at a time but recordset holds only one.