Interested to Buy Any Domain ? << Click Here >> for more details...
Diff. b/w DataReader and DataSet?
- 8 Answers
- 14215 Views
- Avon, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / vivek
First of all both are used for storing data in the front
end.
DataReader:-
1)It is connection oriented.4
2)It is faster because every data must travels through this
object.Even dataset also accesses data through this object.
3)Its navigation is forward only and and read only object
4)It can not be connected to multiple backends at a time
because of connected oriented.
5)Data reader is having record pointer to point the record
6)At a time it can point to only record.
7)we can not know how many records are there in datareader
8) By default It does not point to any record
9)Always it takes recference from the Resultset in the
database.for every it goes to resultset and fetches record
from resultset.
10)By default it supports online update.
DataSet:-
1)It is disconnected because it doesnot know about the
datasource
2)It is slow of its fat structure
3)It is useful for the offline retriving data.
4)It indepedent of Backend
5)Once the data is accessed it is independent of backend we
can make any modifications to that data.
6)Navigation is possible in any direction
7)It doesnot have the record pointer to point record
8)Logically we have to create record pointer.
9)It can have any type of data from different databases.
10)It uses "diffgram" to store the data in the form of xml
format
11)By default it supports Batch Sql update
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Define the executescalar method?
Explain how can we load multiple tables in to dataset?
Define executenonquery?
What is the role of clr?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
Explain the different row versions available in table?
Explain the two fundamental objects in ado.net?
What is ado and rdo?
What is ambient transaction?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What is the difference between ado.net and entity framework?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is ado.net components?
What is data view and variable view?
Define data adapter?
