What?s the role of the DataReader class in ADO.NET connections?
- 7 Answers
- 14781 Views
- Honeywell, Ksb, I also Faced
- E-Mail Answers
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
What are the pre-requisites for connection pooling?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
Define ado.net?
What are the difference between readonly vs. Const?
Which object of ado contains datarow datacolumn collection?
What are two types of transaction supported by ado.net?
What does ole stand for in excel?
What is DataRowCollection?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
How do you find the count of records in a dataset?
What is the difference between typed and untyped dataset?
List the 4 common ado.net namespaces?
Explain the difference between data reader and data adapter?
What is difference between executenonquery and executequery?
What is ado.net tutorial?
