ALLInterview.com :: Home Page            
 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                      
Google
   
 
Categories >> Software >> Microsoft Related >> ASP.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions (614)
 C Sharp interview questions  C Sharp Interview Questions (721)
 ASP.NET interview questions  ASP.NET Interview Questions (1442)
 VB.NET interview questions  VB.NET Interview Questions (150)
 COM+ interview questions  COM+ Interview Questions (41)
 ADO.NET interview questions  ADO.NET Interview Questions (198)
 IIS interview questions  IIS Interview Questions (86)
 MTS interview questions  MTS Interview Questions (5)
 Crystal Reports interview questions  Crystal Reports Interview Questions (62)
 BizTalk interview questions  BizTalk Interview Questions (33)
 Dot Net interview questions  Dot Net Interview Questions (861)
 Exchange Server interview questions  Exchange Server Interview Questions (103)
 SharePoint interview questions  SharePoint Interview Questions (25)
 WCF interview questions  WCF Interview Questions (8)
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions (193)
Question
Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?
 Question Submitted By :: Rajatsachdeva.virgo
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?
Answer
# 1
Dataset is used to get the data from database by creating
objects..After getting data we should store that data.we
use SQLDATAADAPTER for storing data..after storing we will
give connection with SQLCONNECTION class.and then we bind
the data using DATABIND..This total process is appliued
with DATASET.
where as DATAREADER is also for getting data through
database.But it is faster in access.we wont use DATAREADER
because of performance problem..
i too dont know record set..
 
Is This Answer Correct ?    8 Yes 3 No
Irfanpathan
 
  Re: Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?
Answer
# 2
With Dataset can retrive the data from two database like
oracle, SQl and merge in one table. Record set is not
possible.

All representation of dataset is using XML while record set
use COM.

Recordset can not be transmitted on HTTP while Dataset can
be.
 
Is This Answer Correct ?    6 Yes 1 No
Lavanya
 
 
 
  Re: Difference between ADO.net Dataset , ADO Record Set & ADO Data Reader?
Answer
# 3
We use DataSet to retrieve data from database in disconnected mode, but in the data RecordSet it retrieve data in connected mode..
DataSet is designed to work without any continuing connection to the orignal database, but RecordSet is Required a connected environment.
Data in DataSet is bulk loaded, rather than being loaded on demand.
DataSet have no concept of Cursor and current pointer, you can use for each loops to move through data.
 
Is This Answer Correct ?    1 Yes 0 No
Lovenier
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
we can able to display a MessageBox in asp .net without using any script langages? ABC 8
What is the use of location tag in web.config file Karur-Vysya-Bank-KVB 2
What event fired during, when datagrid click?   1
what is the difference between this.controls and page.form1.controls and me.controls? FactorH 2
what is purpose of xml control in standard controls of asp.net   1
What type of code (server or client) is found in a Code-Behind class?   1
Asp.Net Source :- In my project i have gridview control - item template. Its have asp:button control. my requirement is while click this button i need to display some alert message. Could you please help me which gridview event i need to write source code? Please give me a quick response. Thanks   6
how to create textboxes dynamically and insert textbox text into sql database   2
What is the difference between a Thread and Process?   1
i cant get Primary output selection from the Dialog box While Creating Setup and Deployment the web application how to solve it..   1
Types of configuration files and their differences ? Accenture 2
What is the main difference between a static page and a dynamic page?   2
 
For more ASP.NET Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com