Workflow and ServiceDesk Community

 View Only

  • 1.  Stored Procedure with multiple table results to grid

    Posted Jul 12, 2011 04:23 PM

    I have a stored procedure that outputs multiple (3) separate tables. When I use the Stored Procedure generator it will only return the results from the first table. How can I return all three separate tables from the SP resultset? Thanks for any ideas!



  • 2.  RE: Stored Procedure with multiple table results to grid

    Posted Jul 12, 2011 04:37 PM

    I'm unsure if returning multiple datasets is even possible with the SP generator. Would it be possible to split your one SP into 3 SPs that are called separately (one for each dataset)?



  • 3.  RE: Stored Procedure with multiple table results to grid

    Posted Jul 12, 2011 04:57 PM

    Thanks for the reply reecardo. I know that splitting it out to three separate SPs will work but I wanted to check if anyone else has run across this and see if they found any other way around it by keeping with the one original SP. If not, we'll have to settle for splitting it out I guess.



  • 4.  RE: Stored Procedure with multiple table results to grid

    Posted Jul 12, 2011 05:07 PM

    I am running into the same issue. I would like to use one SP and somehow dynamically create gridview tables on a webform based upon how many tables the SP returns. The .NET System.Data library has a DataSet datatype that will store multiple tables, but I am unsure how to integrate this library into Workflow Solution Designer. If someone knows how to integrate the DataSet datatype in to WSD, this would solve both our problems.



  • 5.  RE: Stored Procedure with multiple table results to grid
    Best Answer

    Posted Jul 12, 2011 08:03 PM

     

    If you can create a custom DLL in visual studio that does what you are looking for, you can create a WF integration DLL from that that original DLL. There is a video on www.workflowswat.com showing how to do this.

    the SP generator only returns one Data Type, so unless you are returning the same exact fields for the SP the generator will not work for you.

     

    rob



  • 6.  RE: Stored Procedure with multiple table results to grid

    Posted Jul 18, 2011 12:14 PM

    Being that the DataSet data type in the .NET framework uses classes outside of System.Data, how can a custom DLL be created to account for all the dependencies?