Overview
The purpose of this 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 | ||
|---|---|---|
| ||
CREATE PROCEDURE spHola_Mundo_AccionesTest_Insert
@Data1 nvarchar(50)
@Data2 nvarchar(50)
AS
BEGIN
INSERT Hola_Mundo_AccionesTest(Data1,Data2)
SELECT @Data1, @Data2
END
GO |
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.
...
| Info |
|---|
This step is only needed for synchronization of the Stored Procedure generated in DB. |
How to create a 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.
...
| 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.