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
What is fill method in ado.net?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
How to enable and disable connection pooling?
What are dcl commands?
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
Explain how do you connect to sql server database without using sqlclient?
What are all the different authentication techniques used to connect to MS SQL Server?
What is adodb dll?
How to create data relations?
What are the classes in System.Data.Common Namespace?
can we create synonymn in ms access,sql server,my sql if so explain me with example
Explain the difference in an abstract class and an interface?
Command objects uses, purposes and their methods.
Which database is the ado.net?
What are the 3 major types of connection objects in ado.net?