Stored procedure loaded DataGrid

[DAGamer]

Probably missing something simple, have a DataGrid bound to a stored procedure, but adding/deleting new items does not refresh the data in the grid.

Have to navigate away, then back and then the data changes are shown.

Where is the best place(s) to ensure the DataGrid gets reloaded after add/edit/delete?

Thanks

[enchev]

You are not missing anything - auto-refresh in this case is not supported. You can call load() method of the DataGrid to get latest data.

[DAGamer]

Can you provide an example of how that works, what the code looks like?
So In the RowSelect event, it opens the edit dialog. Do I 'Execute Code' in the 'Then' event to refresh the DataGrid?

[DAGamer]

Found an example here:

Datagrid and custom methods refresh

Hello, I have used a custom method to load joined data to a datagrid, and I have added the delete, edit and add methods like in regular CRUD pages. The issue that I have, is that when I edit a record, everything works fine except that I have to reload the page to see the edited values on the grid. The same happens when adding (can't see the added record in the grid until I refresh). How can I get the grid working as it was a regular crud page (as if it was using a data source method)? Thanks…

[jrfragoso]

You have to execute: setTimeout(()=> {this.grid0.load();}, 0) in the Then even of the Open Dialog method.
The setTimeout() is to avoid the error:

Cannot read property 'load' of undefined.