Call Centers 24x7 Home Page

Your 24x7 call center: (360) 452-4527 Login   Search
Data Binding

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.

    Print      
Data Binding HTML Element Label Element Textfield Element TextArea Element Rich Text Element CheckBox Element CheckBox List Element Radio Button Element Radio Button List Element Select List Element File Upload Element
Copyright (c) 2012 Call Centers 24x7