Difference between datareader and dataset?
- 26 Answers
- 59882 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / anju
- 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 ? | 14 Yes | 6 No |
Post New Answer View All Answers
Which keyword is used to accept variable number of parameters?
What is a sqldataadapter?
What is an example of ordinal data?
How do I delete a row from a DataTable?
Which is faster sqldataadapter and sqldatareader?
What is a dynaset in access?
What is the advantage of ado.net?
What is meant by executenonquery?
How would you connect to a database by using .NET?
What is ambient transaction?
Give few examples of datareader that is used in different dataproviders.
What are two important objects of ADO.Net?
What is different between sqlcommand object and command behavior object?
Which object of ado contains datarow datacolumn collection?
Which is better ole db or odbc?
