Why DataReader is Forward Only?

Answer Posted / vrushali

DataReaader is connected object and one can process the
rows that are returned by query, one at a time. It discards
every row after you have gone through it and so it is
extremely fast.It contains only read-only data, so no
updates are allowed using DataReader
objects.

Is This Answer Correct ?    51 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you fill the gridview by using datatable object at runtime?

546


What is ole db and odbc?

514


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

495


Why is ADO.NET serialization slower than ADO ?

559


What are the key features of ado.net?

659






Which is better entity framework or ado.net?

506


What are the steps you will take to improve performance?

457


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

506


What is the purpose of using adodb?

498


What is the significance of CommandBehavior.CloseConnection ?

562


What are the different ado.net namespaces?

620


What are the data providers used in ado.net

537


What are the major difference between classic ADO and ADO.NET?

510


What is a datareader object?

575


Explain the difference between an ado.net dataset and an ado recordset?

529