Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 66495 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / sagar
Data reader is a connection oriented architecture as its
requires continues connection with Data base.
while Data set is disconnected oriented architecture,
whenever user wants to pull the data he/she build the
connection with Data base.
-Data readers execution is very fast. as it reads only
forward stream.
while
Data set execution is slow as compare to Data reader, as it
carries bundle of data.
- when data changes requires frequently then User should go
for Data set, when user doesn't require data changes
frequently then he/ should go for Data Reader.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define Execute Scalar?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
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 the executescalar method?
Why edit is not possible in repeater?
What is the use of ADO.NET and XML web services?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is the use of sqldatareader class?
What does executereader return?
What is typed dataset ?
What are the rules to implement connection pooling?
What is variable view?
What is ado and rdo?
What does adodb stand for?
How to creating a SqlCommand Object?
