|
Strongly Typed DS from Sproc with >1 Resultset -- Queryitis --
I've searched pretty thoroughly for a solution to this but haven't had much luck. I have a stored procedure (SQL Server 2000) that returns 5 resultsets, and accepts up to 4 parameters. If I manually code a dataset with table mappings and execute the sproc, the tables fill fine. However, the fields are not available for binding to textboxes, etc. in the IDE. If I try to create a dataset using the dataset designer in VS 2005, only the first resultset is returned. Any help is appreciated - this is driving me crazy. Thanks. |