Answer / 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.

Answer / chowdary

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

Answer / srikar

Data-reader:

It is connection oriented.
It is faster.
It is Read only,we can't update the data.
it access one table at at a time.

Data set:

It is dis_connection oriented.
it is slower compare to Data-reader.
It access more one table at a time.
We can update data also.

Answer / febin.j.s

Connected environment is one in which a user can constantly
get connected to a datasourse.so that the data is uptodate.in
connected environment the data concurrency effects can be
easily resolved.connected environment causes network traffic.
But in Disconnected environment the user is not directly
connected to the data source.Here the user can connect to the
data source only when he wants to retrieve the data after that
the connection will be closed(ie: gets connected only when the
DML operations are doing).Disconnected environment allows
multiple applications to simultaneously interact with the data
source.It also improves the scalability and performance of the
applications.

Answer / harikumar m

1.
Connected Uses: Data Provider(It Includes
Connection,DataCommand,DataReader)
Disconnected Uses: Data Set,Data Adapter

2.
Connected: Network traffic is high,poor in Performance
DisConnection: Network traffic is low,Good in Performance

3.

Connected: Data is up to date
Disconnected: Data is not up to date

4.
Connected: 'Join' can be used to relate two tables
Disconnected: DataRelations(a Class) can be used to relate
two tables

5.

Connected: Forward only, and Read Only
Disconnected: Scollable

6.

Connected:Handle single table at a time
Disconnected: Handle multiple table at a time

7.

Connected: Not persisted
Disconnected: Persisted

Answer / vivek

connection oriented: means when ever we get the data the
connection must be exist with backend.we can't be
independent of backend.In connection oriented we cant get
tables or data from different backends.
Ex:select * from emp ->from oracle
select * from dept ->from sql
the above two statement execution is not possible in
connected oriented.
physical binding with backend is compulsary.
where as in disconnected orinted getting data doesn't
require connection open.by itself it looses the connection.
the advantage here is independent of backend we can make
the modifications independent of backend. Binding with
backend question doen't araises.
we can get data or tables from different databases we can
establish relations among them irrespective of from where
they have come.

Answer / varma

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

Answer / pushpendra singh

1. Connected environment needs a constantly connection of
user to data source while performing any operation.
Dissconnected environment does not need any connection.

2..Only one operation can be performed at a time in
connected environment while in dissconnected multiple
operations can be performed.


3...DataReader is used in connected environment.
DataSet is used in dissconnected environment.

4... Connected environent is slower in speed.
Disconnected environment has a good speed.

5.....We get updated data in connected environment>
In disconnectes environment,thereis a problem of
dirty read.

Answer / harikumar m

1.
Connected Uses: Data Provider(It Includes
Connection,DataCommand,DataReader)
Disconnected Uses: Data Set,Data Adapter

2.
Connected: Network traffic is high,poor in Performance
DisConnection: Network traffic is low,Good in Performance

3.

Connected: Data is up to date
Disconnected: Data is not up to date

4.
Connected: 'Join' can be used to relate two tables
Disconnected: DataRelations(a Class) can be used to relate
two tables

Answer / srikanth

Hi.. Questn is about diff b/w connctd and dis connctd. not
b/w reader and data set..

Connected:-
data provider comes under connected eniv. data
povider contains four components
(Connection,Datareader,Command,DataAdapter).
Dissconnected:-
It contains only DataSet.

Connected:-
In this asynchronous or multiple access can be
doing by using MARS(Multiple Active rsult set)
Discon:-
Is used for async

Connected:-
always there is a direct contact to database
disconnected:-
Not required
Connected:-
Less chance of Diry read
disconnec:-
More
Connected:-
Low Perfomance bcz bulk updation is process taking
disconnected:-
can be done easily and update at a time

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.

2 Answers   Fulcrum Logic, Satyam,

What are the parameters that control most of connection pooling behaviours?

0 Answers  

How to add a check box or a dropdown list to a column in a datagrid?

0 Answers  

What are the data providers in ADO.NET framework?

0 Answers  

What is the provider and namespaces being used to access oracle database?

5 Answers   E2E, Microsoft,

How to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  

What is ole access?

0 Answers  

What is ole in excel?

0 Answers  

What is full form of ado?

0 Answers  

What are the main differences between classic ado and ado.net?

0 Answers  

How to fetch the last inserted record in a particular table?

10 Answers   CarrizalSoft Technologies, Microsoft,

What is the difference between connected environment and a disconnected environment?

2 Answers