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

Explain how to create dynamic gridview?

701


Which is faster sqldataadapter and sqldatareader?

693


What is the difference in record set and dataset?

710


What does sqldatareader return?

689


What is the difference between sqlcommand and sqldataadapter?

705


Why do we need ado.net?

721


What are the objects of ado.net?

751


What is the difference between executequery and executenonquery?

692


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

797


Which keyword is used to accept variable number of parameters?

871


Explain sqlconnection object?

745


What is the advantage of ado.net?

743


Which database is the ado.net sql connection object designed for?

801


What are the differences between OLEDB and SQLClient Providers?

758


How to create data relations?

724