GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Microsoft  >  ASP.NET 2.0
Go To First  |  Previous Question  |  Next Question 
 ASP.NET 2.0  |  Question 18 of 161    Print  
Diff between Dataset and Datareader?

  
Total Answers and Comments: 5 Last Update: December 18, 2006   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 11, 2005 09:57:58   #1  
uday        

RE: Diff between Dataset and Datareader?
Data Set is a connectionless service and Data reader is a connection oriented service
 
Is this answer useful? Yes | No
September 23, 2005 01:13:29   #2  
Rupesh krotha        

RE: Diff between Dataset and Datareader?

Dataset is used to store the data it contains collections of Datatable.

Datareader is used to connect to the database for retrieving data.


 
Is this answer useful? Yes | No
March 08, 2006 05:42:41   #3  
praveen_kunwar Member Since: March 2006   Contribution: 8    

RE: Diff between Dataset and Datareader?

What is a DataReader?
A DataReader is a read-only stream of data returned from the database as the query executes. It only contains one row of data in memory at a time and is restricted to navigating forward only in the results one record at a time. The DataReader does support access to multiple result sets but only one at a time and in the order retrieved. Just as in the original version of ADO the data is no longer available through the DataReader once the connection to the data source is closed which means a DataReader requires a connection to the database throughout its usage. Output parameters or return values are only available through the DataReader once the connection is closed.

What is a DataSet?
DataSet is the core of the ADO.NET disconnected architecture and is used to store data in a disconnected state.


 
Is this answer useful? Yes | No
March 14, 2006 05:59:35   #4  
gayathri        

RE: Diff between Dataset and Datareader?

Data Reader - Forward only where as Dataset - Can loop through datas

Data Reader - Connected Recordset where as DataSet - Disconnected Recordset

Data Reader - Less Memory Occupying where as DataSet - It occupies more memory

Data Reader - Only Single Table can be used where as Dataset - Datatable Concept allows data to be stored in multiple tables.

Data Reader - Read only where as DataSet - Can add/update/delete using the dataset

Data Reader - No relationship can be maintained where as DataSet - Relationship can be maintained.

Data Reader - No Xml Storage available where as DataSet - Can be stored as XML.


 
Is this answer useful? Yes | No
December 18, 2006 13:31:59   #5  
Mudduswamy        

RE: Diff between Dataset and Datareader?
The Dataset is an core of disconnected architecture.Disconnected architecture means once you have retriveed the data from the database the connect of the datasource is dropped.The disconnected data become very commonlyThe dataset for the disconnected data from the Dataset object.The DataReader is an readonly forward only stream from the database.While using the datareader can improve the application performance reduce the system overhead because only one buffer row at a time in memory.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape