Output Parameters AND Recordsets From a Stored Procedure (Images)

24 November 2006 - 10:32 PM / by Dominic Pettifer. 1 Image 9 Comments

Technical Article - Just had a frustrating past few hours with Stored Procedures in SQL Server 2005 and ASP.NET. I was trying to return both output parameters and a recordset from the same stored procedure and the caller (a .NET data access class) wasn’t having any of it! I found a solution so thought I better post it here to help others, and in case I forget.

Images

  • Result of Stored Procedure using output params and a recordset

    Result of Stored Procedure using output params and a recordset

Random Image

Tiny hard drive standing next to some dominoes.

These dominoes are getting bigger and bigger every year. (from the blog And So It Begins )

Quick Poll

What is your DIP/IOC Container of choice?

  • 24.5% - Castle Windsor
  • 15.9% - Unity
  • 14.6% - StructureMap
  • 10.6% - Ninject
  • 9.9% - Spring.NET
  • 6.0% - Huh!?
  • 5.3% - None - DIP is the work of Satan!
  • 4.6% - Autofac
  • 4.6% - None - But I want to look into DIP
  • 2.0% - DIY (my own container)
  • 0.7% - PicoContainer.NET
  • 0.7% - LinFu
  • 0.7% - Other
  • 0% - Puzzle.NFactory
  • 0% - S2Container.NET

Thank you for voting!

View Comments (4) (See previous polls)

Latest Tweets

View Dominic Pettifer's Twitter page.