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 we do with the object of ado.net dataset after using it?

530


What is the usage of the dataset object in ado.net?

493


What is the use of adodc?

535


What are the different layers of ado.net?

524


The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

1579






Explain the difference between data reader and data adapter?

516


Explain how to pass multiple tables in datasets simultaneously?

501


What are the data providers used in ado.net

548


How can we save all data from dataset?

551


What is execute reader in ado.net?

504


Which method is used to sort the data in ADO.Net?

1517


What is data control techniques?

518


How to create dynamic gridview?

596


What is sqlconnection and sqlcommand?

531


How to pass multiple tables in datasets simultaneously?

580