Answer / neha

Connected:
In connected environment, the connection object is
constantly opened to operate on the databases, and is closed
after all the operation are performed.
Advantages: fast retrieval of data, updated information is
always accessed
Disadvantage: security threats

Disconnected:
In the disconnected environment, the connection object is
opened for the minimum amount of time, that is, the time
when data is retrieved. After the data is retrieved from the
database, the connection is closed, and all the operations
like INSERT, UPDATE, DELETE, etc are performed offline. The
change during the operation can be reflected back to the
database in the similar manner.
Advantage: no security threats, increase in performance as
connection is not constantly opened.
Disadvantage: slow data retrival.

Answer / pavithra

In connected,an application is constantly connected to data
source.
advantages :
data concurrency is avoided because one user is connected
to a data source and updating data,while another user cant
made changes on data.
In disconnected environment ,application isnt directly
connected to data source.user use connection at once to
retrieve data and connection closed after retreiving.
limitation:
data concurrency.

Differnces between oracle 9i and sql server?

2 Answers   College School Exams Tests, Microsoft,

---

What is data adapter in ado.net with example?

0 Answers  

---

What is execute scalar in ado.net?

0 Answers  

---

How to add a check box or a dropdown list to a column in a datagrid?

0 Answers  

---

Explain the difference in an abstract class and an interface?

0 Answers  

---

how to keep track of index in listbox items.

2 Answers  

---

What is the difference between Data adaptor and Data set?

0 Answers   HCL,

---

What are the different ado.net namespaces are available in .net?

0 Answers  

---

Explain how to create dynamic gridview?

0 Answers  

---

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

0 Answers  

---

What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET ?

1 Answers   Digital GlobalSoft,

---

What does ole stand for in excel?

0 Answers  

---