what are the differences between dataset and datareader?
Answers were Sorted based on User's Feedback
Answer / hardik
dataset is a disconnected architecture while a datareader
is a connected architecture object.
data reader is a faster than a dataset
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / anu
DataSet : you can move forward\backward of the data.It can
be Edited.It acts as a database after the connection is
closed.
Reader : It Just moves forward only.And cannot edit it is
only for Read Only purpose.For this connection object will
be there till u read all the values.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramireddy eevuri
--> Dataset is disconnected architecture while
DataReader is connected architecture.
-->datareader is read only i.e, forward only while dataset
maintain persistanse data.
| Is This Answer Correct ? | 1 Yes | 0 No |
dataset support manpulation,datareader doesnot support
manpulation
datareader is abstract class
dataset is collection of table
datareader is readonly forwardonly record type
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the purpose of using adodb?
What is a non query?
Why is stored procedure used in ado.net?
What is sql command in ado net?
what is Execute NOn Query?
29 Answers Infosys, Protech, Sars Systems, SwanSoft Technologies,
Differnce between Stored procedure and user defined functions?
17 Answers Microsoft, Symphony,
Why is ADO.NET serialization slower than ADO ?
What are the different methods by which we can populate a dataset?
HOW TO FILL GRID VIEW WITH OUT USING SQLDATASOURCE AND PROGRAMING?
What are the namespaces used in ADO.Net to connect to a database?
Which is faster dataset or datareader?
Explain the difference between sqlcommand object and command behavior object?
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)