what is the main difference between disconnected data and connected data which would be the best and why?

Disconnected data-

It means it release the process data from database to application at once it fill to the memory then no connection with the database (connection close).

E.g. when we retrieve data set from database it directly fills it to the memory and then application gets the data from the memory.

Connected data-

It gives the process data to the application continuously without getting the data from memory. e.g. when we retrieve data to data reader, once received the data row from the database then it give the next one also from the database likewise it gives continues data to the application from database.-By pubudu hatangala