Connected Architecture means, a
connection with the Database Server is always maintained. But in Disconnected Architecture, data from the Database Server is downloaded to the ASP.Net
application memory infrequently.
Dataset is a Disconnected Architecture and DataReader is a Connected
Architecture.