Diff b/w DataReader,Dataset and Data table?

Categories >> Software >> Microsoft Related >> ADO.NET
Suggest New Category

Question Posted / manis_venu

5 Answers
9753 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Diff b/w DataReader,Dataset and Data table?..

Answer / nityanand

Dataset:Disconnected Architecure and Relation between Row
and Column
Datareader :Connected architecture and Forward only and
read only data access.

DataTable : It is collection of data Rows and Column.

Is This Answer Correct ?

59 Yes

2 No

Diff b/w DataReader,Dataset and Data table?..

Answer / deepak

DataReader:- is a predefined class that access the data
forward only and read only mode,and it belongs to connected
architechure.
Dataset:- is a buffer location between database and
application.All the manipulation are done here rather than
directly database.it belongs to disconnected architechure.

DataTable:- is the collection of rows and columns in the
dataset.In other sentence,The table in the dataset is called
DataTable.

Is This Answer Correct ?

19 Yes

1 No

Diff b/w DataReader,Dataset and Data table?..

Answer / venu

DataReader: datareader is forward only it is nt scrollable
and datareader fetch the records one by one.this is record
pointer to pointing to one by one record in connected
Architecture.

Dataset:dataset is contain table in Xml format.we can use
this forward to any operating system.it is Scrollable and
dataset contain in application memory.

Datatable: DataTable Contain a structured format it contain
a rows and columns.

Is This Answer Correct ?

4 Yes

3 No

Diff b/w DataReader,Dataset and Data table?..

Answer / sooraj

dataset :-
dataset used disconnected mode(offline architecture) dataset
contain object of data table by using dataadapter by fill
method means dataadapter fill the fetch query of datatable
to data set..

datareader:-
its use connected mode arcetecture..its secure but
connection oriented.. its working some time we can say that
its same as a dataset but its direct access data by table..

datatable :- structured format it contain
a rows and columns.

Is This Answer Correct ?

3 Yes

2 No

Diff b/w DataReader,Dataset and Data table?..

Answer / neha

DataReader: It is used to retrieve a single record of a
table at a time. It does this in forward-only, read-only manner.

DataTable: It is used to represent a single table of the
dataset.

DataSet: It is the collection of DataTables and the
DataRelations.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

How can you add or remove rows from the datatable object of dataset?

0 Answers

What is the difference between a datareader and a dataset?

0 Answers

What is the namespaces being used to access oracle database?

0 Answers

types of Store procedure in Sqlserver2000?