All elements except HTML and FileUpload support dynamic database data binding. In other words data extracted from database tables or stored procedures can be used to bind to an element/field. For example, a table containing look up values for a user address can be used to bind to a SelectList element. When a form is displayed data is automatically extracted and displayed on the field and can be selected like a normal field.
For elements that support data binding, the following properties (under the Data-binding tab) are available when creating or editing the element using the Form Designer:
| Property Name |
Description |
| Source Type |
This field indicate where the data comes from. There are four possible values for this field. Table (DNN): This option indicates that the source table is a DNN type table. DNN typed table is a table that uses the ObjectQualifier attribute in DNN. Table (Non-DNN): This option indicates that the source table is a normal table without using the DNN object qualifier attribute. Stored Procedure (DNN): This option indicates that source data comes from a stored procedure that uses the ObjectQualier attribute in DNN. Stored Procedure (Non-DNN): This option indicate the source data comes from a stored procedure that does not use the ObjectQualifier attribute in DNN |
| Source Name |
Specifies the table name or the stored procedure name of the data source. Stored procedure can have a list of dynamic parameters separated by a commas. Supported dynamic parameters for Stored procedures are: {UID} : User ID of current logged on user {USERNAME} : User name of current logged on user {FULLNAME} : Full name of current logged on user {PORTALID} : ID of the current portal {PORTALNAME} : Name of the current portal {PORTALALIAS} : Alias of the current portal {MODULEID} : ID of the current Enterprise Forms module {PAGEID} : ID of the current page the Enterprise Forms module belong to {PAGENAME} : Name of the current page the Enterprise Forms module belong to {HOSTIP} : IP address of the current logged on user {HOSTNAME} : Host name address of the current logged on user {USERAGENT} : User agent string of the browser Example: SomeStoredProcedureName {UID}, {PORTALID}, 'Hardcoded text'The above stored procedure have 3 parameters, 2 of which are dynamic and the last one is a static value. Note that value that are text should be enclosed in single quote (') |
| Value Column |
Specifies the name of the source table column to bind to the Value field for the element. |
| Text Column |
Specifies the name of the source table column to bind to the Text field for the element. |