Diff. b/w DataReader and DataSet?

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


Please Help Members By Posting Answers For Below Questions

What are the different ado.net namespaces?

837


Explain what is datagrid with an example?

825


how Sequence to connect and retrieve data from database using dataset?

959


Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

888


What two types of data providers does ADO.NET supply? What determines which one you should use?

748


What Is Difference Between Ado And Ado.net?

769


Which is the best method to get two values from the database?

733


Difference between sqlcommand and sqlcommandbuilder?

797


What is openrowset?

709


What is difference between Dataview and Datatable?

744


Does sqlclient and oledb class share the same functionality?

721


How to creating a SqlCommand Object?

822


What are the benefits of using of ADO.NET in .NET 4.0?

743


If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

838


What does ole stand for in excel?

851