Get KoolPHP UI with 30% OFF!

KoolGrid: Data from an SQL Server stored procedure

Clemens
Hi,
I'm transitioning from desktop development to web development.
How can I populate the KoolGrid with data from a SQL Server stored procedure?
I set SelectCommand to "EXEC uspSomeStoredProcedure @parameter = 'parameter_value'" The call to the stored procedure works fine on SQL Server but gives me an error on KoolGrid.
Any ideas how I can get this to run, if at all?
Clemens
Posted Aug 29, 2016 Kool
David
Hi Clemens,
Unfortunately at the moment KoolGrid hasn't supported stored procedure as a select command yet. However, what you could do is run a stored procedure, retrieve the result into an array and use it for a data source class called AdvancedArrayDataSource in KoolGrid/ext/datasources/AdvancedArrayDataSource.php. Please try this and let us know if you have any question. Thanks!
Posted Aug 31, 2016 Kool
Carlos
Hello
I am new to this tool.
I would appreciate if you can share some simple code in order to understand better how to do the serialization
Posted Nov 24, 2016 Kool