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 the differences between dataset.clone and dataset.copy?

713


What is an arraylist?

679


What do you understand by vb.net?

685


Which is the tool which can convert visual basic old version to .net compatibility version?

597


Explain how the .net framework performs automatic memory management.

637






What is the advantage of using system.text.stringbuilder over system.string?

690


Explain the difference between an xml "fragment" and an xml "document."

580


Explain about the ruby interface generator?

637


What is the source code for display the picture in button click event?

773


What is the feature anonymous type?

591


how to get dynamic control array position or its index position?

2123


What is early binding?

598


What are the shadow variables?

668


Explain an assembly and its use?

599


what's ArrayList in .Net (VB.Net or C#).What's the advantageous using ArrayList.

665