Programming Samples

ADO/WFC provides a sophisticated array of data access services, allowing the Visual J++ developer to create rich, data-centric applications. To help you get started using ADO/WFC, this section provides the following set of programming samples:

Sample Description Components Used
Framework Code Provides a runnable framework in which to copy the code examples.
Connection Sample Connects to a data source and executes a simple query that results in a forward-only, server cursor. Connection
Recordset Sample Opens a disconnected Recordset and populates it with the results of a data source query. Performs several Recordset-oriented operations, such as adding, deleting, updating, and canceling local updates. Note that this is a large code sample. You should thoroughly understand the Connection object before trying this sample. Connection, Recordset, AdoProperty, AdoProperties (collection)
Command Sample Uses a Command object to execute a query with parameters. This is a performance optimization mechanism for highly repetitive operations that vary only in the value of the parameters to the operation. Connection, Recordset, Command, Parameter
Asynchronous Command Execution Sample Uses asynchronous mode to allow background population of a cursor. Connection, Recordset, ConnectionEventHandler
Transaction Sample Uses transaction and isolation levels to control data change visibility in applications. Ensures changes are committed or aborted. Connection, Recordset, Transaction
DataSpace Sample Invokes business objects on an application server using the Remote Data Services (RDS) and Internet Information Server (IIS). Marshals the Recordset result back using SOAP (Simple Object Access Protocol). Connection, Recordset, ObjectProxy, DataSpace
Event Handling Sample Hooks up event handlers to process changes in Recordsets, allowing all interested “listeners” to track changes. Connection, Recordset, RecordsetEventHandler, RecordsetEvent
Data Navigation Sample Opens a Recordset and navigates through its cached data. Examines the metadata of the Recordset by iterating through the Fields collection of the Recordset. Connection, Recordset, Field, Fields (collection)

Note   You should begin with the Framework Code sample, which shows how to set up your application. You can then use the code in the other samples to add the desired functionality.