RDS.DataControl Object

See Also   Example   Properties   Methods   

The RDS.DataControl object binds a data query Recordset to one or more controls (for example, a text box, grid control, or combo box) to display the ADOR.Recordset data on a Web page.

Syntax

<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33" ID="DataControl"

<PARAM NAME="Connect" VALUE="DSN=DSNName;UID=usr;PWD=pw;">

<PARAM NAME="Server" VALUE="http://awebsrvr">

<PARAM NAME="SQL" VALUE="QueryText">

</OBJECT>

Remarks

The class ID for the RDS.DataControl object is BD96C556-65A3-11D0-983A-00C04FC29E33.

For a basic scenario, you need to set only the SQL, Connect, and Server properties of the RDS.DataControl object, which will automatically call the default business object, RDSServer.DataFactory.

All the properties in the RDS.DataControl are optional because custom business objects can replace their functionality.

Use one RDS.DataControl object to link the results of a single query to one or more visual controls. For example, suppose you code a query that requests customer data such as Name, Residence, Place of Birth, Age, and Priority Customer Status. You can use a single RDS.DataControl object to display a customer's Name, Age, and Region in three separate text boxes, Priority Customer Status in a check box, and all the data in a grid control.

Use different RDS.DataControl objects to link the results of multiple queries to different visual controls. For example, suppose you use one query to obtain information about a customer, and a second query to obtain information about merchandise the customer has purchased. You want to display the results of the first query in three text boxes and one check box, and the results of the second query in a grid control. If you use the default business object (RDSServer.DataFactory), you need to do the following:

• Add two RDS.DataControl objects to your Web page.
  
  
• Write two queries, one for each SQL property of the two RDS.DataControl objects. One RDS.DataControl object will contain a SQL query requesting customer information; the second will contain a query requesting a list of merchandise the customer has purchased.
  
  
• In each of the bound controls’ OBJECT tags, specify the DATAFLD value to set the values for the data you want to display in each visual control.

There is no count restriction on the number of RDS.DataControl objects that you can embed via OBJECT tags on a single Web page.

When you define the RDS.DataControl object on a Web page, use nonzero Height and Width values such as 1 (to avoid the inclusion of extra space).

Remote Data Service client components are already included as part of the Internet Explorer 4.0 installation; therefore, you don't need to include a CODEBASE parameter in your RDS.DataControl object tag.

Tested Controls

The following table lists the data-aware controls that have been tested to work with the RDS.DataControl object and associated client-side components. Other controls may also work with Remote Data Service, but they have not been tested.

With Internet Explorer 4.0, you can bind to data by using HTML controls and ActiveX^® controls only if they are marked as apartment model controls.

The controls listed are not distributed with Remote Data Service, but may be purchased as part of Microsoft^® Visual Basic^®, Enterprise Edition or from Sheridan Systems, Inc.

Important   You may not redistribute the ActiveX controls that are deployed as a part of Remote Data Service samples in any way. They are provided as part of the sample applications and may not be redistributed to other parties under any circumstances.

Microsoft Visual Basic Users   The RDS.DataControl is used only in Web-based applications. A Visual Basic client application has no need for it.