What is main five diffrent between Connected And
Disconnected environment

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

Is This Answer Correct ?    26 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you fill the gridview by using datatable object at runtime?

550


Why do we use sqldataadapter?

485


What is ole in excel?

522


List all the steps in order, to access a database through ado.net?

587


What are the disadvantages of using datalist?

512






Explain how to find the given query is optimised one or not?

515


Which control of the BindingNavigator returns the current position within the data source?

733


What is sqldatasource?

523


How to retrieve the user id which is provided while windows authentication?

590


How is entity framework different from ado.net?

488


What is the difference between ADO and ADO.Net?

593


What is a datagridview?

518


What is ole in vb?

512


What is data relation?

502


Explain the dataadapter class in ado.net?

663