Updating Data with the ADO Data Control

  • Article

ADO Data Control data can be either read-only or modifiable. To create an application that modifies data using ADO Data Control, do the following.

  1. Set ADO Data Control CursorLocation property. Options are:

    • Server Side

    • Client Side

  2. Set ADO Data Control LockType property. The optimistic concurrency is recommended.

  3. Set ADO Data Control CursorType property. Options are:

    • Keyset Cursor

    • Dynamic Cursor

    • Static Cursor

    Make sure the OLE DB provider supports the chosen option.

  4. Set the data-bound control's properties, as needed, to allow updatability. Note that some controls do not allow updating.

Refer to the ADO documentation for more information on these properties; see Getting Help on Controls.

Back to Using ADO Databinding in Visual C++.