Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between Dataset and Datareader?
- 7 Answers
- 30982 Views
- I also Faced
- E-Mail Answers
Answer Posted / vasudha.g.n
DataReader
Datareader is like a forward only recordset. It fetches one
row at a time so very less Network Cost compare to DataSet
(Fetches all the rows 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.
DataSet
DataSet is always a bulky object that requires lot of
memory space compare to DataReader. We can say the dataset
as a small database coz it stores the schema and data in
the application memory area. DataSet fetches all data from
the datasource at a time to its memory area. So we can
traverse through the object to get required data like
qureying database.
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
what is common language specification?
What is an application domain? how they get created?
Explain the difference between an xml "fragment" and an xml "document."
How does vb.net achieve polymorphism?
what is diffrence constructor and destructor in vb
How many classes a dll can contain?
Described strong typing and weak typing?
What are the different types of Lock available in Visual Basic?
Explain the use of new keyword?
Name some different types of control?
What is the top .net class that everything is derived from?
What are the differences between c# and visual basic.net?
What is the use of system.diagnostics.process class?
What is the significance of delegates. Where should they be used?
Is vb.net dead?
