Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Dataset and DataReader?
- 3 Answers
- 9227 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of using MVC programming pattern in ASP.NET?
What are the page life cycle events?
How ASP.NET page works?
What is rending process in ASP.NET?
What is the exact purpose of http handlers?
What are url fragments?
What are the namespace classes used in asp.net mvc? : asp.net mvc
What are the new data controls in asp.net 2.0?
Just by seeing the signature of the bean how can you specify whether it is a stateful or stateless session bean?
Which is faster viewdata or viewbag?
What is the significance of proxy user?
Can you explain autopostback?
What are the properties of the eventargs argument when capturing keyboard events?
What are the different properties of server control that exists?
What are the different types of events are occured when a client requests an ASP.NET page from IIS server?
