Skip to content

step-5-datacontrol-is-made-usable-rds-tutorial.md

Latest commit

 

History

History
42 lines (36 loc) · 2.76 KB

step-5-datacontrol-is-made-usable-rds-tutorial.md

File metadata and controls

42 lines (36 loc) · 2.76 KB
title Step 5: DataControl is Made Usable (RDS Tutorial) | Microsoft Docs
ms.prod sql
ms.prod_service connectivity
ms.technology connectivity
ms.custom
ms.date 11/09/2018
ms.reviewer
ms.topic conceptual
helpviewer_keywords
RDS tutorial [ADO], datacontrol made usable
ms.assetid ed5c4a24-9804-4c85-817e-317652acb9b4
author MightyPen
ms.author genemi

Step 5: DataControl is Made Usable (RDS Tutorial)

The returned Recordset object is available for use. You can examine, navigate, or edit it as you would any other Recordset. What you can do with the Recordset depends on your environment. Visual Basic and Visual C++ have visual controls that can use a Recordset directly or indirectly with the aid of an enabling data control.

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.

For example, if you are displaying a Web page in Microsoft Internet Explorer, you might want to display the Recordset object data in a visual control. Visual controls on a Web page cannot access a Recordset object directly. However, they can access the Recordset object through the RDS.DataControl. The RDS.DataControl becomes usable by a visual control when its SourceRecordset property is set to the Recordset object.

The visual control object must have its DATASRC parameter set to the RDS.DataControl, and its DATAFLD property set to a Recordset object field (column).

In this tutorial, set the SourceRecordset property:

Sub RDSTutorial5()  
   Dim DS as New RDS.DataSpace  
   Dim RS as ADODB.Recordset  
   Dim DC as New RDS.DataControl  
   Dim DF as Object  
   Set DF = DS.CreateObject("RDSServer.DataFactory", "https://yourServer")  
   Set RS = DF.Query ("DSN=Pubs", "SELECT * FROM Authors")  
   DC.SourceRecordset = RS         ' Visual controls can now bind to DC.  
...

See Also

Step 6: Changes are Sent to the Server (RDS Tutorial)
RDS Tutorial (VBScript)