Diff b/w DataReader,Dataset and Data table?

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

Question Posted / manis_venu

5 Answers
10423 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

Give few examples of datareader that is used in different dataproviders.

0 Answers

What is read only and forward only in ado.net?

0 Answers

Which is faster ado.net or linq?

0 Answers

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers

What is data adapter in ado.net with example?

0 Answers

what is the syntax code for oldb to connect oracle

3 Answers IBM,

What is dataset object? Explain the various objects in dataset.

0 Answers

What are the Data providers in ADO.Net?

0 Answers

Is it possible to edit data in Repeater control?

0 Answers

How is entity framework different from ado.net?