...

...

...

...

...

...

...

...

...

Overview

In this lesson, we will learn how to create a “Dynamic Grid” control under the page. This option allow us to generate multiple columns in a grid without spending a lot of time using the “Grid Column” controls for each column that we want to display on the page. This is an easy way to make an association between the tables or stored procedures previously generated in Database to print the registers in the application.

How to create a Stored Procedure and a new Dataset for “Dynamic Grid” control ?

As precondition to create a “Dynamic Grid” control, we need to connect to the Database in SQL and create a new Stored Procedure like we did in previous lessons.

...

If we edit the dataset and focus on “Columns” tab, you can observe that the same 3 columns are generated automatically in Wayfast at the Dataset:

...

How to create a “Dynamic Grid” control?

Now that we generated the preconditions, we can easily create the “Dynamic Grid” control by selecting the control and click on “New” button in the same page that we worked on.

...

Not that the setup is completed, let’s click on “Preview” button to verify that the “Dynamic Grid” control is showing all the columns and data retrieved from the stored procedure.

...

Recap

This control give us the possibility to create a grid in our pages by just connecting the stored procedure, and the most important thing to keep in mind, there’s no need to create multiple “Grid Column” controls for each column in grid.

...