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

Insanely Cute Hamster

Insanely Cute Hamster (from the blog And So It Begins (part 2) )

Quick Poll

What is your DIP/IOC Container of choice?

Poll Vote
(see results)
View Comments (0) (See previous polls)

Latest Tweets

  • Red Bull gives you wings....that generate huge amounts of downforce #F1

    about 18 hours ago from Twitterrific

  • .vampire { -webkit-box-shadow: none; -webkit-box-reflection: none; } #cssjokes

    7:44 PM July 30th from Echofon

  • @edhenderson lol, lets get a trending topic going - .gangster .wrapper { color: #000; width: 150%; text-decoration: bling; } #cssjokes

    7:36 PM July 30th from Echofon

  • @weblivz I think the petition should be resubmitted but with security stuff taken out, as that's what the response purely focused on

    6:13 PM July 30th from Echofon

  • @weblivz I still think Chrome Frame can come to the rescue here, still keep their old browsers + legacy systems, no retraining costs etc.

    6:12 PM July 30th from Echofon

View Dominic Pettifer's Twitter page.