What is the Difference between Dataset and Datareader?

Answer Posted / anitha

Dataset is cache of records retrieve from data source.
Datareader is used to retrieve data from datasource.

1.Using Datareader we can read the data readnly,forwordonly
basis.
2.Only one record in a memmory at a tme
3.Faster
4.Doesnot hold any data
5.Data can not be transfer to datasource
Wher as in Dataset
1. we can read and write and allow us to navigate through
the records forword and backwords.
2.Pulls the records from the datasource and saves in IIS
memmory.
3.Slower
4.Holds datatables and has the information about
relationship between those tbes.
5.Data can be transfer to datasource

Is This Answer Correct ?    34 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between metadata and manifest?

565


Explain jit?

546


What is branching logic control in VB.NET?

570


What is the top .net class that everything is derived from?

612


What is the difference between a "jagged array" and multidimensional array" ?can anyone show me it practically ?

551






How vb implements the disconnected architecture as like vb.net?

581


Explain about branching logic control in vb.net?

535


What do you mean by serialization and deserialization?

542


what is the advantage of option strict on?

602


What is early binding?

527


Why should you use delegate?

473


Before in my vb app I would just load the icons from dll. How can I load the icons provided by .net dynamically?

517


Explain how to store decimal data in .net?

711


Explain the difference between value and reference types?

456


How do you retrieve the customized properties of a .net application from xml .config file?

516