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

Explain ado.net features?

546


How to store data in memory?

510


What is ado rdo dao in visual basic?

673


What is the difference between OLEDB Provider and SqlClient?

535


How can I retrieve two tables of data at a time by using data reader?

522






how Sequence to connect and retrieve data from database using dataset?

764


What is ole access?

556


What is shadow copy?

588


Does ado.net use odbc?

531


What are the disadvantages of using datalist?

519


What is ado.net full form?

560


Does executenonquery return a value?

548


What are dcl commands?

512


What is the difference between DataReader and DataSet in ADO.NET?

596


What is datasource in ado.net?

590