Overview
In this lesson we are going to review Wayfast Datasets. A dataset allows us to connect a 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 have 2 important preconditions before start working with Datasets.
...
A popup is displayed, click on “Synchronize” button. Now the stored procedure created in database will be available to connect with dataset.
How to create a new Dataset?
Go to “Project Pages” at top menu. Select any of the pages available in the project. Then click on “New Dataset” button
...
This is how it looks like:
...
How to connect the new Dataset with a
...
“Grid Column” control?
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.
...
Click Let’s create an example using grid columns linked to the new dataset.
Turn to the page where we are going to include this object. Under the “Controls” section, choose the “Grid Column” option. Click on “New” button
| Info |
|---|
You can find more details regarding the properties on “Grid Column” control lesson. |
...
A popup will be prompted to generate the control.
...
Turn to “Data Binding” tab and connect to a previously generated dataset.
...
Turn to “Layout” tab and indicate the order where we want to display this column. In our example, we have a table created and we want to add this new column at the right side.
...
Click on “Submit” button
...
Now that we have the grid columns created, we can click on “Grid_Column” link in “Control” column in the row we want to bind . A popup is displayed with the information related to the control. Turn to “Data Binding” tab
...
| 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 database 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.