Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Using the Stored Procedure Caller Generator in Workflow Solution

Created: 27 Apr 2009 • Updated: 09 Sep 2010
ChrisBern's picture
0 0 Votes
Login to vote

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