Using the Stored Procedure Caller Generator in Workflow Solution

This short video walks through an example of calling a database stored procedure from a Workflow Solution project. This particular stored procedure requires input parameters, and so I will demonstrate how to initially capture the parameter data in a webform, and then pass the input parameters to the stored procedure dynamically at runtime. The resulting recordset that the procedure call returns will then be displayed in a grid component on a webform.

Keywords: Stored Procedure Caller Generator, Create Integration Library, database provider, DLL, WebForms project, connection string, SQL Server, tables, complex datatype, input parameters, project property, query, import components, form builder, label, DatePickerComponent, process variables, DateTime, array, GridViewComponent, collection handling