Why DataReader is Forward Only?

Answer Posted / manumole

A DataReader is a stream of data that is returned from a
database query. When the query is executed, the first row
is returned to the DataReader via the stream. The stream
then remains connected to the database, poised to retrieve
the next record. The DataReader reads one row at a time
from the database and can only move forward, one record at
a time. As the DataReader reads the rows from the database,
the values of the columns in each row can be read and
evaluated, but they cannot be edited.

Is This Answer Correct ?    19 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which method is used to sort the data in ADO.Net?

1502


What is data control techniques?

505


What is ado recordset?

494


Explain the difference between sqlcommand object and command behavior object?

532


What is the difference between ado.net and entity framework?

502






What is the difference between OLEDB Provider and SqlClient?

526


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

586


What is the hierarchy of data in databases?

498


Data reader read and forward only, how is it possible to get 2 tables of data at a time?

488


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

578


What is sqldatasource?

521


Is ado.net an orm?

510


What is the use of connection object in ado.net?

562


Can you explain how to enable and disable connection pooling?

501


What is ado rdo dao in visual basic?

647