Diff b/w DataReader,Dataset and Data table?

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

Question Posted / manis_venu

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

WHAT Are the major major compnents of a data provider in ADO.net.

14 Answers Infosys, Wipro,

How to identify the controls which can be used for binding data?

0 Answers

What is difference between ado and other data object?

0 Answers

Define isolation?

0 Answers

What is sql command in ado net?

0 Answers

Why sql Data Reader object not created

9 Answers Matrix,

What is the usage of the dataset object in ado.net?

0 Answers

We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?

6 Answers Accenture, FastStream,

Is ADO.NET derived from COM? true /false

2 Answers Infosys,

i have two textboxes one for user name and another for password . i have a table name compare(which contains name,passwod etc.,)my doubt is how compare username textbox with name column and how compare password textbox with passwod column. i want the code

9 Answers Wipro,

What two types of data providers does ADO.NET supply? What determines which one you should use?

0 Answers CDC,

what are the differences between dataset and datareader?

4 Answers Choice Solutions,

For more ADO.NET Interview Questions Click Here