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

F1      Select  Setting , Database Connection

f2

f3

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)

f4Select Database Function. Create a Lookup

f5

Update All Parameters as Shown In image.and validate the vie. the Selected Query Function display the result as shown below.

f7

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

f9

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.

f10

Configure the Properties of Data Grid Control.

f45as seen in image , configure the configuration name.

After Applying Properties , Check the Preview of Form.

f15

Last modified: Thursday, 21 May 2020, 12:32 PM