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

What are the main differences between classic ado and ado.net?

516


What is microsoft ado.net?

578


What is the provider being used to access oracle database?

499


Which method is used by command class to execute SQL statements that return single value?

552


What are the different methods by which we can populate a dataset?

685






What is ado net stands for?

516


What is the difference between dataset and datatable?

485


What are the objects of ado.net?

527


What is an example of ordinal data?

485


What is ado oledb and odbc?

503


What is the return type of executescalar?

493


What is row state?

523


What is ado full form?

504


What is ado circle?

660


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

547