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. Let’s review how we can make this interaction possible in Wayfast.
Preconditions
We have 3 important preconditions before start working with Datasets.
We need to connect the project with an existing or new database. You can find more details about in another lessons where we attached or created databases.
We need to create a table or identify the table where we are going to get the data to display using the Dataset
We need to create an object in this database, for example, an Stored Procedure to link the table and interact with Dataset information.
How to create a Stored Procedure in DB and link to Dataset?
A Stored Procedure is an object that we can define and then relate it to the Project. This needs to be created in DB using SQL.
...
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
...
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 a “Grid Column” control?
Let’s create an example using grid columns linked to the new dataset. It’s important to complete the “Field” value with the same parameter created in Stored Procedure. In this example, we are going to use “Name”, “Role” and “Email” at “Field” that matches with the stored procedure previously added to database.
...
All the information in the table is now available in the page. In the following lesson, we are going to analyze how we can insert values on the table using “Actions” feature.
Recap
In the first part, we learnt how Pages interact with database by creating Datasets. Then we made a first approach using SQL to create a simple Stored Procedure that was linked to Dataset. In the second part, we explained how the Controls under pages can display in different ways the information available on database, assigning the place and source. In the next lessons, we will learn how to connect the Controls with Actions that user will have in pages to make the application more dynamic.