Overview
The purpose of In this lesson is explain the Dataset in Wayfast. This entity allow we are going to review Wayfast Datasets. A dataset allows us to connect the Controls with our Project DB and bring the information to make it available in any page whenever is neededa page with a data source like a database or an API. To depict how it works we will show you and example that include calling a database store procedure for retrieving information and displaying it in a Wayfast Application.
Preconditions
We need to create a Stored Procedure to interact with Dataset information
...
| Info |
|---|
This step is only needed for synchronization of the Stored Procedure generated in DB. |
How to create a new Dataset?
Turn Go to “Project Pages” at top menu. Select any of the pages available in the project. Then click on “New Dataset” button
...
Let’s verify the information available from DB and connect them to the Project, we need to make it visible in the application’s layout.
How to connect the new Dataset with Grid controls created?
If we create a new dataset and the page already has controls associated to a different dataset, let’s focus on “Controls” section. In this example, we have 3 grid columns linked to an old dataset.
...
| Info |
|---|
If page has multiple grid columns to reassign, we can use “Massive Mod” button which is a 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.