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 the typical session identifier?
A Web Service Can Only Be Written In .net. Is it True??
how to retrieve property settings from xml .config file.
What types of data validation events are commonly seen in the client-side form validation?
Why do we use asp.net?
How do you deploy your asp.net application?
What is voluum?
Explain the difference between singleton and single call?
What is a Cookie? Where is it used in ASP.NET?
What is difference between view and partial view?
What type of code, client-side or server-side, is found in a code-behind file of a Web page?
What are the various ways to send content from one page to another?
What is event bubbling?
Is asp.net outdated?
What do you mean by authentication?