Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 67325 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
What is difference between Dataview and Datatable?
Which object is used to add relationship between two Datatables?
What is Data Provider?
How do you merge 2 datasets into the third dataset in a simple manner?
What is the difference between Command and CommandBuilder object?
Explain the difference in record set and dataset?
How to connect and retrieve data from database using dataset
What is the difference between typed and untyped dataset?
What is ado.net objects?
What is sqldatasource?
How to find the given query is optimised one or not?
What is ambient transaction?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
Explain how to find the given query is optimised one or not?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
