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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   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
 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 ?    0 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 ?    0 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 ?    0 Yes 0 No
Eduardo Belmonte
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
what is postback implementation?when pre-render event n init event is fired? Ness-Technologies1
hai to all. what is the procedure for " web hosting ".If you know please message me at "yoursguna@gmail.com". Thank u...  1
What is FullTrust? Do GACed assemblies have FullTrust?  2
what is diff between responseexpires and expiresabsolute Accenture2
what is the MSIL assembler do?  1
Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe in the page loading process.  1
Tell About Web.config ? Keane-India-Ltd2
Is overloading possible in web services? Microsoft2
Can we change the page layout in ASP.NET 2.0 as Grid Layout like in previous version TCS2
Can you edit data in the Repeater control?  8
You ve defined one page_load event in aspx page and same page_load event in code behind how will prog run?  3
When would you not use the oleDbConnection object? a) To connect to an SQL 7.0 database. b) To connect to a DB/2 database. c) To connect to an Access database. d) To connect to an SQL 6.5 database. Syntax-Softtech4
what is diference between the .net1.0 & .net2.0 ? EMax2
Features and disadvantages of dataset ? Microsoft3
We have 2 sites in which one site allows the user with out asking credentials and second one ask for credentials through a log page. What might be the configurations settings for both sites? We can use IIS and web.config files together. ADITI1
What methods are fired during the page load?  2
How we can bind textbox,listbox and datagrid to sql server database in asp.net using visualstudio.net language (vb.net)? rocsearch1
I am trying to redirect another site on button click.  6
What is cookie less session? How it works?  1
Types of session management in ASP.NET ? Microsoft1
 
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