RDTA.PickDP.WebExtensions.table Control

The table control represents a single table in a database. This control enumerates all connection controls on the local web (.aspx) and the global.asax form, allowing you to create non-persistent applications. The table control displays a list of all local and global connection controls found in the active project.  Note that the code for the local connection requires that you open and close connections and tables before accessing data. For example:

 

Connection1.open()

Table1.open()

DbDataBinder1.Fill()

Table1.close()

Connection1.close()

Public Constructors

New

Constructor.

Public Methods

close

Closes the table.

deleteItem

Deletes an item from the table.

FillCombo

Fills the specified combo boxes associated with this table.

FillListBox

Fills the specified list boxes associated with this table.

getConnection

Gets the connection Object to access to the database.

getDatabase

Gets the connDatabase Object that is accessed by the table.

getItem

Gets an item from the table.

getNoExist

Gets the read status of the item being read.

getTable

Returns the connTable representing this table.

isConnected

Returns the connection status.

isLocked

Returns the locking status of the item being read.

isOpen

Returns whether the table is open or closed.

MemberwiseClone

Returns a copy of the current instance. For internal use only.

open

Opens the table. The table name to open is indicated by the TableName property.

release

Releases locks of all items for the current table.

releaseId

Releases the lock for the current item.

setConnection

Sets the connection Object of the table.

setconnTable

Sets the connTable Object. Provides the ability to change data source (connTable) at runtime.

setItem

Writes an item to the table.

Public Properties

Name

Type

Description

Connection

RDTA.PickDP.WebExtensions.connection

Gets or sets the connection.

ConnectionName

String

Gets or sets the connection name.

IsLocalConnection

Boolean

When creating a global.asax application, you can add a connection control to the global.asax form or any webform.aspx form. This property:

  • returns True when the connector control used exists on the current webform.aspx form.

  • returns False when the connector control used exists on the global.asax form.

LockType

String

Gets or sets the lock type.

SubTableName

String

Gets or sets the subtable name (data section).

TableName

String

Gets or sets the table name.

Public Events

Name

Type

Description

onAfterDelete

Event

Event triggered after a delete.

onAfterOpen

Event

Event triggered after an open.

onAfterRead

Event

Event triggered after a read.

onAfterWrite

Event

Event triggered after a write.

onBeforeDelete

Event

Event triggered before a delete.

onBeforeOpen

Event

Event triggered before an open.

onBeforeRead

Event

Event triggered before a read.

onBeforeWrite

Event

Event triggered before a write

onRecordLocked

Event

Event triggered when attempting to read, write, or delete a locked record.

onRecordNotExist

Event

Event triggered when attempting to read a record that does not exist.

 

5