ASP.NET ADO.NET

ActiveX Data Object (ADO) provides two models for retrieving data from an SQL Database

Forward-Only Data

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.