In VB.NET, the dataset stores records retrived from database in computer's memory. However if the underlying query fetches many records (say 1 million) how does dataset store so many records in memory? Is there any way to control how many records will be retrieved from database before dataset is disconnected from data source?

Thanx