Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Dataset and DataReader ?
- 4 Answers
- 17628 Views
- Accenture, BirlaSoft, Infosys, Microsoft, Techseol, I also Faced
- E-Mail Answers
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
Is session stored in browser?
What are type/key pairs in client script registration?
Who creates jsessionid?
How many types of sessions are there in asp net?
What is the use of dispose method?
What is the difference between application state and caching?
How do we implement bundling in MVC?
What is the file extension of web service?
What tags do you need to add within the asp:datagrid tags to bind columns manually? How?
What is ispostback method in asp.net? Why do we use that?
Is asp.net easy to learn?
What happens if an ASP.NET server control with event-handling routines is missing from its definition?
1.What r collections? 2.What is .pdb file? 3.Is it possible to provide access to users in master page? 4.What is dirty n Phantom Read(SQL)? 5.What r different isolation levels(SQL)? 6.How to set authentication mode in web.config file?
Define the term Scavenging in Caching?
What is http only cookie?
