What are the differences between Dataset and DataReader?
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
Is it possible to write code in many languages in one asp.net project?
How to implement globalization and localization in the use interface in .net.
What is inproc and outproc?
Explain the difference between asp & asp.net.
Can viewstate be accessed in another page?
How many web config files can be created for an application?
What is the significance of proxy user?
What is the use of view state?
What New Features comes with ASP.NET Web API 2.0?
Define resource files.
What is difference between view and partial view?
I have an external link in my application say www.xyztest.com. Today this site works on http protocal. Tommorow it may run on https. So i cant hardcore the protocal in the site. When a user clicks on the link how can i know if the external site works on http or https and takes him to that place?
Explain the basic functionality of garbage collector?
What is autopostback in dropdownlist in asp net?
What are the different authentication modes in asp.net?