Difference between Dataset and DataReader ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / satish
The DataSet consists of a collection of DataTable objects
that you can relate to each other with DataRelation
objects. A DataSet can read and write data and schema as
XML documents..The DataReader object is the ADO.NET
counterpart of the read-only, forward-only default ADO
cursor
| Is This Answer Correct ? | 17 Yes | 3 No |
Answer / payal
1)Data set is work in diconnected architure.
Datareader is work in connected architure.
2)according to speed datareader is faster than dataset.
3)In case of dataset it contain all
tables,relations,constriants which is not in datareader so
that speed of datareader is fast.
4)Data set can persist records where datareader is not.
5)we can save ,update data in dataset and save using
acceptchanges method where datareader cannot.
6)datareader is forward only.where dataset is not.
| Is This Answer Correct ? | 18 Yes | 8 No |
Answer / kamlesh sharma
The DataSet consists of DataTable objects
that you can relate to each other with DataRelation
objects (and dataset is disconnected data model)
The datareader is connected model(connection must be open
while operation performs)
and it is state forward read only counter part of ADO.net
| Is This Answer Correct ? | 8 Yes | 3 No |
What is a page life cycle? What are the events in a page life cycle?
Explain the use of duration attribute of @outputcache page directive.
difference between <connectionstring> <Appsetting>
Explain how asp.net page works?
Describe the events in the life cycle of a web application.
How u refer webservices?
How many types of validators are there in asp net?
What property must you set, and what method must you call in your code, in order to bind the data from a data source to the Repeater control?
How to execute a stored procedure.and how to call it form a asp page
What are Authentication mechanisms in .Net?
Write a code snippet to implement the indentation in json in web api.
What is the asp.net mvc folder conventions? : asp.net mvc
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)