ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ASP.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
Difference between Dataset and DataReader ?
 Question Submitted By :: Pranab Mukherjee
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Difference between Dataset and DataReader ?
Answer
# 1
The DataSet consists of a collection of DataTable objects 
that you can relate to each other with DataRelation 
objects. A DataSet can read and write data and schema as 
XML documents..The DataReader object is the ADO.NET 
counterpart of the read-only, forward-only default ADO 
cursor
 
Is This Answer Correct ?    6 Yes 1 No
Satish
 
  Re: Difference between Dataset and DataReader ?
Answer
# 2
DataSet

Data set can be said as a temporary data base which works 
on disconnected architecture which stores schema and data 
in application memory area..It fetches all data at a time..
DML is entertained here

DataReader

Datareader is like a forward only recordset. It fetches one
row at a time.DataReader is readonly so we cannot do any 
transaction on them. DataReader will be the best choice 
where we need to show the data to the user which requires 
no transaction ie reports. Due to DataReader is forward 
only we cannot fetch the data randomly. .NET Dataproviders 
optimizes the datareaders to handle the huge amount of data.
 
Is This Answer Correct ?    5 Yes 0 No
Umamahadevan
 
 
 
  Re: Difference between Dataset and DataReader ?
Answer
# 3
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 ?    3 Yes 2 No
Payal
 
  Re: Difference between Dataset and DataReader ?
Answer
# 4
The DataSet consists of  DataTable objects 
that you can relate to each other with DataRelation 
objects (and dataset is disconnected data model)

The datareader is connected model(connection must be open 
while operation performs)
and it is state forward read only counter part of ADO.net
 
Is This Answer Correct ?    3 Yes 1 No
Kamlesh Sharma
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
What is machine.config and web.config ? Digital-GlobalSoft4
What?s a bubbled event? Visual-Soft5
What is the use of web.config? Difference between machine.config and Web.config?  3
What are Sticky Sessions? Infosys2
Can we throw exception from catch Block? Accenture6
What is difference between machine.config and Web.Config? Accenture3
How many classes can a single .NET DLL contain? SoftSol5
Types of authentications in ASP.NET ? Accenture5
How do you create a permanent cookie?  2
What is the Difference between user and server controls?  4
In what order do the events of an ASPX page execute. As a developer, why is it important to understand these events? Syntax-Softtech5
How Can we use multiple forms in single asp.net application? Polaris2
What combination of methods are used to improve the speed of the fill() method of the DataAdapter? a) BeginFillData() and EndFillData() b) StartFillData() and EndFillData() c) BeginLoadData() and EndLoadData() d) StartLoadData() and EndLoadData() Syntax-Softtech2
What is viewstate? Microsoft4
Explain authentication levels in .net ?  3
what to magage the state manament in asp.net with respect to in_prock and out_prock Aviva1
How many types of session in asp.net2.0 HCL17
When maintaining session through Sql server, what is the impact of Read and Write operation on Session objects? will performance degrade..  2
how to convert varchar into datatype int............. in ASP  1
7. Do you have reference list? Swatz-Oils1
 
For more ASP.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com