ActiveX Data Object (ADO) provides two models for retrieving data from an SQL Database
Use this model if you want to display stream of rows (e.g. database table rows) on a control without further data manipulation.
In-Memory Data Model
Use this model if you want to use the default paging system of a datagrid or require firther data manipulation such as editing or sorting.