Connected or Disconnected mode in ADO.NET

Question

Hi friends,

I want to know that what will be the real life example of connected and disconnected approach in ADO.NET and which will be best for use?