Why DataReader is Forward Only?

Answer Posted / nevin jain

from all 11 above answer only Sachin Gupta have given write
answer...
becoz SqlDataReader inherit DbDataReader whose base type is
IEnumerable that use to access collection through simple
iteration which is forward only manner...

Basically SqlDataReader Class access records n retrieve them
as collection through simple iteration...

to make more clear first read Functionality of IEnumerable
interface that expose GetEnumerator() method...

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to create dynamic gridview?

521


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

536


Explain ado.net features? Benefits? Drawbacks?

558


What is shadow copy?

581


What are the types of databinding?

557






What is serialization and de-serialization in .net? How can we serialize the dataset object?

520


Explain the two fundamental objects in ado.net?

509


What is the provider being used to access oracle database?

505


Explain how to call the sql commands asynchronously in ado.net version 2.0?

514


Is it possible to load multiple tables in a Dataset?

533


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

597


What is Data view?

566


What are three methods for displaying data in a syncfusion datagrid

614


How to load multiple tables into a dataset?

544


Why do we use sqldataadapter?

485