Why DataReader is Forward Only?

Answer Posted / sandyni

As we know that DataReader is connected architecture it
cannot persists the contents. it reads the contents one by
one record from the dataset until all the records completed.

The main thing is data reader uses pointers to fetch the
next record(index).hence these are the forward only objects

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is commandbuilder in ado.net?

704


Explain the difference between ado and ado.net?

679


Define data adapter?

677


What are the key events of sqlconnection class?

828


What is the difference between ADO and ADO.Net?

792


What are the parameters that control most of connection pooling behaviours?

791


What provider ado.net use by default? Explain the role of data provider in ado.net?

716


How do you update a dataset in ado.net and how do you update database through dataset?

669


Which keyword is used to accept variable number of parameters?

867


What is the significance of CommandBehavior.CloseConnection ?

804


What is the difference between sqldatareader and sqldataadapter?

689


Which is faster sqldataadapter and sqldatareader?

688


Some important instruction regarding ADO.NET connection string ?

731


How to add a check box or a dropdown list to a column in a datagrid?

717


What is the purpose of using adodb?

683