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
What does postback mean?
Why asp.net is used?
In Data grid the question is below quantity price total these are 3 fields available in data grid if you enter quantity the total has to update automatically.Price field is already filled completely
What is mvc in asp.net tutorial? : Asp.Net MVC
Explain the difference between debug.write and trace.write? When should each be used?
Explain about asp.net state management?
How do we ensure view state has not tampered?
What is bson in web api?
What is difference between viewstate and session state in javascript?
What is the latest version of asp.net?
Can a .net web application consume java web service?
Explain server-side scripting and client-side scripting.
If you want to bind the columns manually within the asp:datagrid tags what kind of tags you have to add.
Explain the working of passport authentication.
Is global asax mandatory?