| title | Refresh Method (RDS) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.technology | connectivity | |||
| ms.custom | ||||
| ms.date | 01/19/2017 | |||
| ms.reviewer | ||||
| ms.prod | sql | |||
| ms.prod_service | connectivity | |||
| ms.topic | conceptual | |||
| apitype | COM | |||
| f1_keywords |
|
|||
| helpviewer_keywords |
|
|||
| ms.assetid | c90a8050-0ff4-4c83-9925-261f2f2ccfe9 | |||
| author | MightyPen | |||
| ms.author | genemi |
Requeries the data source specified in the Connect property and updates the query results.
Important
Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and Windows Server 2012 Compatibility Cookbook for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to WCF Data Service.
DataControl.Refresh
DataControl
An object variable that represents an RDS.DataControl object.
You must set the Connect, Server, and SQL properties before you use the Refresh method. All data-bound controls on the form associated with an RDS.DataControl object will reflect the new set of records. Any pre-existing Recordset object is released, and any unsaved changes are discarded. The Refresh method automatically makes the first record the current record.
It is a good idea to call the Refresh method periodically when you work with data. If you retrieve data, and then leave it on a client computer for a while, it is likely to become out of date. It is possible that any changes that you make will fail, because someone else might have changed the record and submitted changes before you.
Refresh Method Example (VB)
Refresh Method Example (VBScript)
Address Book Command Buttons
CancelUpdate Method (RDS)
Refresh Method (ADO)
SubmitChanges Method (RDS)