Now we need to configure the data source settings with the Db that we are going connect with this tenant.
For that in the left pane of the ClaysysAppForms there you can see the links section. In that take Data Management tab and click Data-source Settings.
Open the SQL server management studio and copy the source server name.
Now paste the source server name in the respective column, then set the credentials and type the name of the database in the server that we are going to use.
Then create a new form in the AppForm designer.
As shown in the below figure, in the ‘Data’ from the ‘Toolbox’, select the Control ‘Dynamic Grid’ then drag and drop it to the form and change the properties.
Click on the dynamic grid control and select DataSources in the pop-up and click New DataSource Configuration.
In the dynamic grid configuration window add columns as needed and click next button when completed.
Select the data source and click next button.
Then select the data source object (table name) and click next.
Select the columns required from the table.
All the selected columns will be listed in the next page and more columns can be added.
Select the command to configure and click on Add button.
Map the controls to the Data source column and click Ok button.
And the execute command rule is created.
Take the form preview and enter the values and click submit button.
Go to the database then select the table and load the first 1000 values.
And the rule is created for the selection command.
Load the form and enter any ID value and click ‘Select’ button.
Load the form and then give any ID to load the values to the grid.
Then edit the values and then click Update button to update the values.
You can see that the new value is updated in the Data base as well as selected in the controls after the update.
After deletion there will be no record for given ID