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

Explain the dataadapter class in ado.net?

0 Answers  

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

0 Answers  

If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()

4 Answers  

What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?

5 Answers  

How would you connect to a database by using .NET?

0 Answers  

How to sort the data in Datatable

2 Answers   NetProphet,

How to aggregating data across related tables?

0 Answers  

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency

4 Answers   Digital Group,

What are the different row versions available in table?

0 Answers  

Which namespaces are used for data access?

0 Answers   SwanSoft Technologies,

Give few examples of datareader that is used in different dataproviders.

0 Answers  

What is acid in ado.net?

0 Answers