Answer Posted / venu
DataReader: datareader is forward only it is nt scrollable
and datareader fetch the records one by one.this is record
pointer to pointing to one by one record in connected
Architecture.
Dataset:dataset is contain table in Xml format.we can use
this forward to any operating system.it is Scrollable and
dataset contain in application memory.
Datatable: DataTable Contain a structured format it contain
a rows and columns.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What are the main differences between classic ado and ado.net?
What is connection pooling and what is the maximum pool size in ado.net connection string?
What is the difference between typed and untyped dataset?
Define executenonquery?
What is the use of sqldatareader class?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What is execute reader in ado.net?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
Why is ADO.NET serialization slower than ADO ?
What is data adapter in ado.net with example?
What is Data Provider?
Which is the feature of ado.net?
What are the 3 major types of connection objects in ado.net?
What is the executescalar method?
