What?s the role of the DataReader class in ADO.NET connections?

Answer Posted / ajay singh negi

DataReader object is a simply used to read data from the
result sets and because of this feature we call this object
as forward only or read only cursor. It requires a live
connection with the data source. Threw looping you can
efficiently access all or a part of data from the result
set. Note you cannot directly initialize a DataReader
object. Execute reader method of the command object is used
to obtain a valid DataReader object. After using DataReader
you need to close the connection otherwise it is stayed
alive and it is explicitly closed.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

505


What is disconnected data?

577


What is openquery?

525


How to copy the contents from one table to another table and how to delete the source table in ado.net?

517


What are the data access namespaces in .NET?

622






What is the full form of ado.net?

504


How to perform sorting on a table in ADO.NET?

549


What is an ADO.Net?

562


Which is better ole db or odbc?

493


can we create synonymn in ms access,sql server,my sql if so explain me with example

1568


What are the pre-requisites for connection pooling?

529


Which control of the BindingNavigator returns the current position within the data source?

728


Can we connect two dataadapters to same data source using single connection at same time?

526


What does adodb stand for?

500


Some important instruction regarding ADO.NET connection string ?

536