Topic 5.3.3: Form Design Example
In this example , we will check How to Connect SQL Database and hot to Display the SQL Data in the Form.
Database Connection :
Go to Enterprise , Select Repository Link, Login to the Repository, from the Navigation menu
Select Setting , Database Connection
Create A New Connection List as Seen In Above image
After That Again Go to the setting And Select Lookup Setting(we are using Lookup Setting for the SQL Query to Perform Database Function)
Select Database Function. Create a Lookup
Update All Parameters as Shown In image.and validate the vie. the Selected Query Function display the result as shown below.
After that for Displaying the Above table in Form, you have to Configure the Data Grid.Select Setting>Data Grid>Create New Data Grid>Select Lookup Name and Configure the Grid As shown Below
For Form Design , Go to the Navigation menu in Dashboard select form,In form tab select create new form.
Select The Data Grid Control from Designer.
Configure the Properties of Data Grid Control.
as seen in image , configure the configuration name.
After Applying Properties , Check the Preview of Form.