Special Edition Using Microsoft® Visual Basic® .NET

Using Disconnected Recordsets

If you have worked with older VB data access technologies, you will find that ADO has features that allow you to manipulate data in ways that were never before possible. For example, in most traditional applications a recordset in your program is always linked to the underlying database. As long as the recordset is loaded into memory, you are maintaining an active connection to the database. However, the rise of the Internet and “loosely connected” applications have brought about the concept of a disconnected recordset. This term means that you can have a recordset in memory that is not attached to a database. Disconnected recordsets can be manipulated independently of the database, saved to disk, and synchronized ...