Use this constant to get or set the value of the database parameter that specifies whether cursor context preservation is on or off. If cursor-context preservation is on (TRUE), a COMMIT does not destroy an active result set (cursor context). This enables an application to maintain its position after a COMMIT, INSERT, or UPDATE. The cursor context is not preserved after an isolation level change. The context is preserved after a ROLLBACK if both of the following are true: The application is in the Release Locks (RL) isolation level. A DDL operation was not performed. If cursor-context preservation is off (FALSE), a COMMIT does destroy an active result set. Cursor context preservation is lost. Use this constant with the SqlGetParameter, and SqlSetParameter functions. Value = 3

public const int DBP_PRESERVE