Updating Data with the ADO Data Control

The new home for Visual Studio documentation is Visual Studio 2017 Documentation on docs.microsoft.com.

The latest version of this topic can be found at Visual Studio 2017 Documentation. ADO data control data can be either read-only or modifiable.

To create an application that modifies data using ADO data control

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 updateability. Note that some controls do not allow updating.

For more information about these properties, see the ADO documentation.

See Also

ADO Databinding
Using ADO Databinding in Visual C++