Difference between Dataset and DataReader ?

Answer Posted / payal

1)Data set is work in diconnected architure.
Datareader is work in connected architure.

2)according to speed datareader is faster than dataset.

3)In case of dataset it contain all
tables,relations,constriants which is not in datareader so
that speed of datareader is fast.

4)Data set can persist records where datareader is not.

5)we can save ,update data in dataset and save using
acceptchanges method where datareader cannot.

6)datareader is forward only.where dataset is not.

Is This Answer Correct ?    18 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the events in the life cycle of a web application.

603


How can we call webservices in Banking Applications? and where we are using it?

1538


What is IPostBack? How to use it?

602


Define satellite assemblies.

587


What is smpte vc-1?

556






Hello, Using Visual Studio 2005 (VB) I am working to create a Web Site implementing the following: Within a gridView I have placed a dropdownlist control with a DataSourceID="SDSLkupList". SDSLkupList is a sqlDataSource used to store a lookup list for dropdownlist translation from ID to text. SDSLkupList contains the translation text and other fields related to the dropdown selection ID. (Thought it would be efficient to get everything at the same time.) I would like to provide the user the ability to select from the dropdownlist and, based on the selection, use labels to list related columns stored on the SDSLkupList in separate gridView columns. I have read that SqlDataSources are not meant to be used for individual controls. Since SDSLkupList contains all related information, is there a way to do a find using the dropdownlist selectedValue? (I was not able to discover one.) Otherwise, what should I use? It would need to set the labels on the gridView DataRowBound event as well as the SelectedIndexChanged events. Has anyone done this? Any help would be appreciated. Thanks in Advance. Neal

1379


Which data type does the rangevalidator control support?

559


What is the used of "ispostback" property?

569


Explain how cookies work.

600


What is the base class from which web forms are inherited?

528


Explain the difference between globalization and localization techniques

540


What is difference between asp.net and asp?

566


What is difference between viewstate and session state in javascript?

580


Explain how does asp page work?

578


What is localhost in asp.net?

570