What is main five diffrent between Connected And
Disconnected environment
Answer Posted / neha
1.Connected: It works when connection object is opened.
Disconnected: It works regardless of the connection object
state (opened or closed doesnot matter).
2.Connected: It can retrieve data from single table only.
Disconnected: It can retrive data from multiple tables.
3.Connected: The data persists even after the shutdown of
application.
Disconnected: The data doesnot persist after the application
closure, as it was all programmatic.
4.Connected: We get the updated data always.
Disconnected: The data we retrieve is not guaranteed to be
updated.
5.Connected: Fast access to the data.
Disconnected: Slow access to data.
6.Connected: It is useful in the scenarios where data is
updated rapidly, for eg, stock market.
Disconnected: It is useful in the scenarios where data is
not updated usually, for eg, school database, where data is
changed after one year only.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is dataset object? Explain the various objects in dataset.
Explain what are acid properties?
What is disconnected data?
Explain the difference between data reader and data adapter?
What are the Data providers in ADO.Net?
Define ado.net?
What is the executescalar method?
What is difference between datatable and dataset?
How can we save all data from dataset?
How to retrieve the user id which is provided while windows authentication?
Define data adapter?
how we can fire event in databound coulm in datagfrid withot using button?
Explain the role of data provider in ado.net?
What is the DataTableCollection?
Which parameter of ConnectionString is used to specify the name of the database?