SP result sets

Unsupported feature

When a DataWindow uses the stored procedure as the data source, the stored procedure can have only one result set to populate the DataWindow object, and cannot have multiple result sets. Because when generating the C# model for the DataWindow, the columns of only one result set will be defined; if there are multiple result sets, the number and type of columns may not match with that of the C# model.

Workaround

Modify the stored procedure to return only one result set.

Or use multiple DataWindows (instead of one DataWindow) for multiple result sets.