Overview
The purpose of this document lesson is explain the Dataset in Wayfast. This entity allow us to connect the Controls with our Project DB and bring the information to make it available in any page whenever is needed.
Preconditions
We need to create a Stored Procedure to interact with Dataset information
| Code Block |
|---|
...
This SP will have 2 parameters. Once that the Stored Procedure is created, we can go back to Wayfast application and synchronize the SP in the environment.
...
On Wayfast, focus on the left side navigator page and click “End Task” button related to project’s requirement.
...
NOTE: This step is only needed for synchronization of the Stored Procedure generated in DB.
How to create new Dataset?
On Page detail, click “New Dataset” button
...
Now that we have the information available from DB and connected to the Project, we need to make it visible in the Application’s UI.
How to connect the new Dataset with Grid controls created?
If create a new dataset and the page already has “Grid” controls associated to a different dataset, focus on “Controls” section. In this example, we have 3 grid columns linked to an old dataset.
...
Change the “Dataset” dropdown with the new dataset retrieved. Click “Accept” button
| Info |
|---|
NOTE: If page has multiple grid columns to reassign, Wayfast has a “Massive Mod” feature to easily make the bulk change |
...
. |
...
Recap
We learnt about the importance of Datasets to interact with DB and how the Store Procedure is needed for this purpose. We explained how some type of controls are specifically created to show the information from the Dataset to make it available at the moment we open the page.
...