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   SiteMap shows list of All Categories in this site.
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
What are the differences between Dataset and DataReader?
 Question Submitted By :: Poojitha
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are the differences between Dataset and DataReader?
Answer
# 1
Dataset is in memory representation of the Database. where 
you can create tables, relations between tables, add 
primary key to tables and also manipulate the data 
retrieved form the database. It allows us to work in 
connection less environment.

Datareader is like forward only readonly cursor, which is 
used to retrieve data. data manipulation is not possible 
while using datareader. datareader continously keeps the 
connection open.
 
Is This Answer Correct ?    4 Yes 0 No
Kautilya
 
  Re: What are the differences between Dataset and DataReader?
Answer
# 2
dataset is a connectionless service but data reader is a 
connection oriented service..
 
Is This Answer Correct ?    1 Yes 0 No
Saravanan
 
 
 
  Re: What are the differences between Dataset and DataReader?
Answer
# 3
A ds (dataset) can be used when the connection is closed.
A dr (datareader) needs the connection open to be used.
 
A ds can be used to modify or delete or insert data in the 
database. 
A data reader can be used only to read data

A ds can let you access the info on any order at any time.
A dr lets you access the info only one time per item and 
only in a sequential order.

A ds data can be loaded in longer time than a dr can be 
loaded at.

A ds can contain separated and structured data from several 
database tables. 
A dr can contain data in one register per item, that 
register can include data from serveral tables id the sql 
select statement so indicates, but it has no separate 
structure per table.
 
Is This Answer Correct ?    4 Yes 0 No
Eduardo Belmonte
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
What method must be overridden in a custom control? a) The Paint() method b) The Control_Build() method c) The Render() method d) The default constructor Syntax-Softtech1
what is client back feauture ?  1
How Many types of Page Load functions in asp.net  2
Interface have Default Modifier Is 'Public'.Where We Will Use The KeyWord In Interface? Phoenix-Technologies3
Difference between abstract factory pattern and factory method pattern in .NET with example. Keane-India-Ltd1
Hi , I am Basha. I am searching a job in dotnet.Plz tell me the order of page events in asp.net 2.0> plz send faq's related to c#.net,asp.net,sqlserver2000 etc. to my mail-id : bashask.ss@gmail.com Sapient4
Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and passwords). Which one is trusted and which one is untrusted?  2
What namespace does the Web page belong in the .NET Framework class hierarchy?  2
What are the page level transaction and class level transaction? Satyam1
what is the assembly?  2
How does dataset acts in a disconnected fashion ? TCS3
What is CTE in sql server 2005? Minecode2
What does the "EnableViewState" property do? Why would I want it on or off? Syntax-Softtech1
What are the different authentication modes in the .NET environment?  2
What methods are fired during the page load?  1
Difference between .NET components and COM components? Microsoft1
Which template must you provide, in order to display data in a Repeater control?  1
Which of the following hosts Can't be used to create .net Application? a) IIS b) Internet Explorer c) ASP.Net d) Windows Shell Which one is correct? CTS1
Tell About Web.config ? Keane-India-Ltd2
How do you add a javascript function for a link button in a datagrid? Microsoft2
 
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