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

Which parameter of ConnectionString is used to specify the name of the database?

0 Answers  

Can I use One Data Set for More than one Data Adapter?

6 Answers  

How to you declare connection strings and how to you make use of web.config ?

3 Answers   MMTS,

Which database is the ado.net?

0 Answers  

How to generate XML from a dataset and vice versa?

2 Answers  

Which is faster sqldataadapter and sqldatareader?

0 Answers  

Explain ado.net features?

0 Answers  

What are two important objects of ADO.Net?

0 Answers  

Explain the differences between oledb sql server, oledbdotnet provider?

0 Answers  

What is datatable?

3 Answers  

What is shadow copy?

0 Answers  

What do you mean by ‘batch updates’?

0 Answers