What?s the role of the DataReader class in ADO.NET connections?

Answers were Sorted based on User's Feedback



What?s the role of the DataReader class in ADO.NET connections?..

Answer / ajay singh negi

DataReader object is a simply used to read data from the
result sets and because of this feature we call this object
as forward only or read only cursor. It requires a live
connection with the data source. Threw looping you can
efficiently access all or a part of data from the result
set. Note you cannot directly initialize a DataReader
object. Execute reader method of the command object is used
to obtain a valid DataReader object. After using DataReader
you need to close the connection otherwise it is stayed
alive and it is explicitly closed.

Is This Answer Correct ?    6 Yes 0 No

What?s the role of the DataReader class in ADO.NET connections?..

Answer / guest

returns a read-only dataset from the data source when the
command is executed.

Is This Answer Correct ?    8 Yes 3 No

What?s the role of the DataReader class in ADO.NET connections?..

Answer / satyambabu

the data reader on the other hand is directly connected to
the database management syatem .it is passess the all
quries to database managemant system,which execute them and
returns the result back to the application.
datareader no maintain the buffer
it is used to small number of operations

Is This Answer Correct ?    5 Yes 1 No

What?s the role of the DataReader class in ADO.NET connections?..

Answer / senthil kumar

DataReader has play vital role in ADO.NET when retrieve the
dataset.Its forward and read only optiion.They are not have
the pointer.It can only move the record with value
pointer.It is effiecnt data retrieval mechnism in ADO.Net.

Is This Answer Correct ?    5 Yes 1 No

What?s the role of the DataReader class in ADO.NET connections?..

Answer / kamal

This is used to retrieve data from a data source in read-
only and forward-only mode

Is This Answer Correct ?    3 Yes 1 No

What?s the role of the DataReader class in ADO.NET connections?..

Answer / santosh

Data reader is belongs to connecting architectutre.It read
the the data in forward direction.It retrive data from
database through sqlcommand.It is faster as comapre to data
Adupter in disconnecting architecture.

Is This Answer Correct ?    2 Yes 3 No

What?s the role of the DataReader class in ADO.NET connections?..

Answer / ilayaraja

it is used to retrieve the records in forward only
manner.it is always connected with data source. also fast
retrieval of records when compared to other (dataset..).

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More ADO.NET Interview Questions

What is disconnected scenario in entity framework?

0 Answers  


ADO and ADO.NET differences?

3 Answers   Microsoft,


How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

0 Answers   CGI,


What is a non query?

0 Answers  


What is ado asp?

0 Answers  






What is the default view of Data Grid?

5 Answers   TCS,


describe the dataset object in ado.net.

0 Answers  


What is the purpose of using adodb?

0 Answers  


What is the main difference between ADO and ADO.Net

4 Answers   HCL,


Explain ado.net features?

0 Answers  


What is the difference between data reader and data adapter?

0 Answers  


What are all the different authentication techniques used to connect to MS SQL Server?

0 Answers  


Categories