Connected and Disconnected in ADO.net

Question

Hi What is connected and disconnected environment in ADO.net?

Jignesh Trivedi · Answer

hi In Connected environment application is continuously connected to the data source. DataReader & Data Adaptor are the example of connected example of environment. DataSet is the example of disconnected environment. In Connected environment data is always current and updated but they lead to network traffic. In Disconnected environment application will connect with the data source only to retrieve the data or when the data needs to be updated. Please refer http://msdn.microsoft.com/en-us/library/27y4ybxw%28v=vs.71%29.aspx hope this will help you.

Sudhakar Chaudhary · Answer

hi Aman simple tutorial (ppt)

Satyapriya Nayak · Answer

Hi Aman Please refer the below links http://www.codinghub.net/2010/12/connected-and-disconnected-environment.html http://etutorials.org/Programming/ado+net/Part+I+ADO.NET+Tutorial/Chapter+1.+Introduction/1.2+Connected+and+Disconnected+Data/ Thanks