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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ADO.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 is main five diffrent between Connected And 
Disconnected environment
 Question Submitted By :: Ankit Kumar Singh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is main five diffrent between Connected And Disconnected environment
Answer
# 1
Dataset is disconnected method where Datareader treated as 
connected method.

Connected methods gives faster performance where as 
disconnected get low in speed and performence.

connected  can hold the data of single table, where as 
disconnected can hold multiple tables of data.

Disconnected are the forward only and readonly objects 
where as connected or not.
 
Is This Answer Correct ?    3 Yes 9 No
Sandyni
 
  Re: What is main five diffrent between Connected And Disconnected environment
Answer
# 2
connected data needs connection to be created to access
hence slower while disconnected is in memory data thats
faster access.

to access connected data you use ADO.NET whereas for
disconnected you do not use.

disconnected-data can be accessed from multiple tables in a
dataset.
connected- .net runtime creats an instance of the datatable
to hold data.

in disconnected data you can create a window to the
datatable in the form of a dataview used to sort and filter
data..which cannot be done in connected data access

connected you need to use a read only forward only data
reader,disconnected you cannot.

disconnected data in a dataset can be serialized/deserialized.
 
Is This Answer Correct ?    3 Yes 0 No
Pratik
 
 
 
  Re: What is main five diffrent between Connected And Disconnected environment
Answer
# 3
Data Reader:-
Data Reader is a read only and forward only data
You can access one table at a time.
Data reader cant persist the data.
Data Reader is connected architecture.
Data Reader is faster than Data Adapter
Data Reader is faster than dataset operation
Data Set:
Data Set is disconnected architecture.
Data Set is persist the data.
You can access more than one table
Data Set is main for storage tool in ADO.Net
 
Is This Answer Correct ?    1 Yes 0 No
Chowdary
 
  Re: What is main five diffrent between Connected And Disconnected environment
Answer
# 4
Data Reader is a forward only and read only data
DataSet is used to maintain relationships between multiple
tables.

Data Reader can't persist the data
Data Set can persist the data
 
Is This Answer Correct ?    0 Yes 0 No
Varma
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
Whate are different types of Commands available with DataAdapter ?  2
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? Techno-Labs2
make a login control??  1
what is Sql Native Client? Gantec-Solutions4
If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation? Honeywell4
How to generate XML from a dataset and vice versa?  2
What are the functions of oledbdataadapter?  3
If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ? Ksb12
What is ADO .NET and what is difference between ADO and ADO.NET? Ksb7
What are the different namespaces used in the project to connect the database?  3
Explain different methods and Properties of DataReader which you have used in your project?  2
What is method to get XML and schema from Dataset?  2
What is ODP.NET ? TCS1
what is data access layer? Honeywell2
How to get oledb connection?  3
Differnce between Stored procedure and user defined functions? Microsoft14
what is the syntax code for oldb to connect oracle IBM2
Difference between datareader and dataset? Microsoft12
What are the three Ado objects? Microsoft5
What is a dataset?  2
 
For more ADO.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