What are the differences between Dataset and DataReader?
Answers were Sorted based on User's Feedback
Answer / kautilya
Dataset is in memory representation of the Database. where
you can create tables, relations between tables, add
primary key to tables and also manipulate the data
retrieved form the database. It allows us to work in
connection less environment.
Datareader is like forward only readonly cursor, which is
used to retrieve data. data manipulation is not possible
while using datareader. datareader continously keeps the
connection open.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / saravanan
dataset is a connectionless service but data reader is a
connection oriented service..
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / eduardo belmonte
A ds (dataset) can be used when the connection is closed.
A dr (datareader) needs the connection open to be used.
A ds can be used to modify or delete or insert data in the
database.
A data reader can be used only to read data
A ds can let you access the info on any order at any time.
A dr lets you access the info only one time per item and
only in a sequential order.
A ds data can be loaded in longer time than a dr can be
loaded at.
A ds can contain separated and structured data from several
database tables.
A dr can contain data in one register per item, that
register can include data from serveral tables id the sql
select statement so indicates, but it has no separate
structure per table.
| Is This Answer Correct ? | 7 Yes | 0 No |
Define the types of configuration files.
What are the differences between Dataset and DataReader?
Give me one example of Web API Routing?
What is Difference between Callbacks and Postback in ASP.NET?
When using the Pager object, inorder to know which page to go, which property you have to set to grid?
How can you debug an ASP page, without touching the code?
1 Answers Prodigy Technologies,
Write some code using interfaces, virtual methods, and an abstract class`
What is .Net3.0 and .Net3.5? Describe something about that Features..
What is the default timeout for a cookie?
WSDL means?
RequiredFieldValidator--write code in javascript
How to Open any web page by clicking any Any ASPControl like (Checkbox,radio button or Button) without calling its event and without going to Siverside code?
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)