What are the differences between Dataset and DataReader?
- 3 Answers
- 8056 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 application session?
How do you design a website with multilingual support in ASP.NET ?
What is request and response in asp.net?
Explain Areas in MVC?
In your ASP.NET 2.0 web application you want to display an image that is selected from a collection of images. What approach will you use to implementing this?
What is the purpose of master page?
What does uri mean?
What does aspcompat="true" mean?
Can we have multiple master pages in asp net?
Describe the .net base class library.
What is the difference between c# and .net?
Explain the difference between the web config and machine config.
List the events in page life cycle.
What are cookies in asp.net?
Explain how can you debug your .net application?
