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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories >> Software >> Microsoft-Related >> ADO.NET
 
 
 
Question
explain connection less and with connection?diference 
between data reader,data set,data adapter? can we use data 
reader,data set in a single application? if yes explain 
with simple code,if no explain?
 Question Submitted By :: Raghu_113
I also faced this Question!!     Rank Answer Posted By  
 
Answer
in connection less architecture connection to the database
need  not be persist till the end of the process.after
fetching the data form database it is pushed in database
object called  dataset and connection object need not to be
persist and its closed. and the data will be available from
the dataset.


data reader - ADO.NET DataReader to retrieve a read-only,
forward-only stream of data from a database. Using the
DataReader can increase application performance and reduce
system overhead because only one row at a time is ever in
memory.Connection to the database is maintained till the
end.it is simply like an ado object.it contains only one
table at a time.it is much  faster than dataset.


dataset - is used to hold the data from the database along
with their relation. it is connection less object.it also
persist the value which  are retrieved form the database.
it is a bit bulky object.it gives both forward and backward
access to data. it uses XML.it can consist more than one
table.we have atrribtes for the dataset 


dataset
    datatable
       datarow
        datacolumn

an adapter object is used to fill the data from the   database.

dataadapter - dataadapter is a database object which
used  to fill the dataset object with data from the database.
 
4
Kavitha
 
View All Answers
 
 
 
 
 
   
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