ADO » Objects » DataControl

The DataControl object allows the Recordset object to be bound to an HTML tag so that the data can be displayed on a web page.

Properties

Connect

Syntax: string = datacontrolobject.Connect
datacontrolobject.Connect = string

Sets or returns a string value that is the ADO connection string name.

ExecuteOptions

Syntax: adcExecuteOptionEnum = datacontrolobject.ExecuteOptions
datacontrolobject.ExecuteOptions = adcExecuteOptionEnum

Sets or returns whether an asynchronous execution is enabled. An asynchronous execution allows control to go back immediately to the calling program.

FetchOptions

Syntax: adcFetchOptionEnum = datacontrolobject.FetchOptions
datacontrolobject.FetchOptions = adcFetchOptionEnum

Sets or returns an adcFetchOptionEnum value that indicates the type of the asynchronous fetching.

FilterColumn

Syntax: string = datacontrolobject.FilterColumn
datacontrolobject.FilterColumn = string

Specifies the column on which to evaluate the filter criteria. Does not activate the filter.

FilterCriterion

Syntax: string = datacontrolobject.FilterCriterion
datacontrolobject.FilterCriterion = string

Sets the filter criteria. Does not activate the filter.

FilterValue

Syntax: string = datacontrolobject.FilterValue
datacontrolobject.FilterValue = string

Sets the value of the filter. Does not activate the filter.

InternetTimeout

Syntax: long = datacontrolobject.InternetTimeout
datacontrolobject.InternetTimeout = long

Sets or returns a long value that is the number of milliseconds to wait before a request is timed out because there is no activity.

ReadyState

Syntax: adcReadStateEnum = datacontrolobject.ReadyState

Sets or returns an adcReadStateEnum value that defines the progress status as a DataControl object retrieves data into a Recordset object.

Recordset

Syntax: Recordset = datacontrolobject.Recordset

Returns the Recordset object underlying the DataControl object.

Server

Syntax: string = datacontrolobject.Server
datacontrolobject.Server = string

Sets or returns the server protocol which can be an HTTP URL, an HTTPS URL, the machine name, or the empty string "" to signify local in-process use.

SortColumn

Syntax: datacontrolobject.SortColumn = string

Sets or returns the column on which to perform a sort.

SortDirection

Syntax: boolean = datacontrolobject.SortDirection
datacontrolobject.SortDirection = boolean

Sets or returns a Boolean value that defines the direction of the sort.

SourceRecordset

Syntax: Set datacontrolobject.SourceRecordset = recordsetobject

Sets the Recordset object underlying the DataControl object.

SQL

Syntax: string = datacontrolobject.SQL
datacontrolobject.SQL = string

Sets or returns the SQL query string.

URL

Syntax: string = datacontrolobject.URL
datacontrolobject.URL = string

Sets or returns a relative or absolute URL.

Methods

Cancel

Syntax: datacontrolobject.Cancel

Cancels the asynchronous fetching of data.

CancelUpdate

Syntax: datacontrolobject.CancelUpdate

Cancels a new row or all changes to the current row.

CreateRecordSet

Syntax: Set recordsetobject. = datacontrolobject. CreateRecordSet(ColumnInfos)

Creates and returns an empty (unpopulated) and disconnected Recordset object.

Refresh

Syntax: datacontrolobject.Refresh

Refreshes the data from the data source, discards any unsaved changes, and positions the Recordset object at the first record.

Reset

Syntax: datacontrolobject. Reset BooleanValue

Used to sort and filter data in a client-side Recordset object.

SubmitChanges

Syntax: datacontrolobject.SubmitChanges

Sends all of the pending changes in the locally cached Recordset object down to the underlying data source.

Events

onError

Syntax: onError(SCode, Description, Source, CancelDisplay)

This event can be fired to handle errors encountered by DataControl.

onReadyStateChange

Syntax: onReadyStateChange

The onReadyStateChange event can be fired when the value of the ReadyState

This event can be fired when the value of the ReadyState property changes.This is a convenient way to check on the progress of a Recordset as it receives new data.This event has no parameters.