MDAC 2.5 SDK - OLE DB Providers
Cursor Service for OLE DB
You can access the rowset by using ADO and OLE DB interfaces. In ADO, use the Recordset object to maintain currency and manipulate the data. The Recordset object exposes methods implemented by the Cursor Service to position on a row, get field values, and filter and sort the rows based on one or more fields. A Recordset object can be cloned, which produces a second Recordset object based on the same underlying rowset data. Clones have their own currency, filter, and sort order, but they share the same set of data. The Cursor Service also generates events exposed by the associated rowset and used to bind rowset data to visual controls. Rowsets can be persisted in an internal binary format or in Extensible Markup Language (XML) format. A client rowset can be remoted between two processes or machines over DCOM or HTTP, enabling distributed data access for multitier architectures over intranets and the Internet.