What is main five diffrent between Connected And
Disconnected environment

Answer Posted / pratik

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 ?    114 Yes 35 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the pre-requisites for connection pooling?

539


What is bubbled event?

535


What is the use of sqldatareader class?

477


What is openquery?

529


how we can fire event in databound coulm in datagfrid withot using button?

574






How can we check that some changes have been made to dataset since it was loaded?

518


can we create synonymn in ms access,sql server,my sql if so explain me with example

1583


What is DataReader Object?

596


How can we load multiple tables in a dataset?

535


What is difference between executenonquery and executequery?

472


What is the return type of executescalar?

495


What is the namespaces being used to access oracle database?

519


What is ambient transaction?

508


What is basic use of data view?

512


Explain the differences between oledb sql server, oledbdotnet provider?

552