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

How to aggregating data across related tables?

556


What is the default timeout specified for "sqlcommand.commandtimeout" property?

547


What is ado full form?

506


What are the connected and disconnected modes in ado.net?

491


How many major types of connection objects in ADO.NET?

597






Explain how to create dynamic gridview?

521


Explain the architecture of ado.net?

543


What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

585


Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

560


What is disconnected scenario in entity framework?

538


What is a column variable?

505


What does adodb stand for?

514


What is ado circle?

667


How is it possible to get 2 tables of data at a time by using data reader?

501


How to add an aggregate column?

537