Difference between Dataset and DataReader ?
Answer Posted / umamahadevan
DataSet
Data set can be said as a temporary data base which works
on disconnected architecture which stores schema and data
in application memory area..It fetches all data at a time..
DML is entertained here
DataReader
Datareader is like a forward only recordset. It fetches one
row at a time.DataReader is readonly so we cannot do any
transaction on them. DataReader will be the best choice
where we need to show the data to the user which requires
no transaction ie reports. Due to DataReader is forward
only we cannot fetch the data randomly. .NET Dataproviders
optimizes the datareaders to handle the huge amount of data.
| Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
What is global.asax file used for?
Demonstrate Render and PreRender?
What is the use of execute non query in asp.net?
What are the data controls available in asp.net?
Mention few asp.net validators.
What is the difference between server-side scripting and client-side scripting?
What is the usage of DelegatingHandler?
What are strong names?
What are the different types of Caching techniques in ASP.NET?
What is the difference between ldap and active directory?
What is difference Between Authentication and authorization?
What is state management in asp.net with example?
14. What are your Future Plans for Swatz Oils GROUP U.K?
Describe the events in the life cycle of a web application.
How does session work in asp net?