?
Solved

Enterprise Library 3.1 Catch Return value from stored procedure

Posted on 2007-10-11
2
Medium Priority
?
1,304 Views
Last Modified: 2009-05-05
Hi,
I am using Microsoft Enterprise library 3.1 in my DataAccessLayer. My stored procedure has a return value
How do i get my return value in my code in DataAccessLayer... I have seen Outputparameter values can be easily retrieved . but how about return values from stored procedure . If return =-1 I want to catch it in my code

like      Create procedure sp_GetEmployee
               Select * from employee
                       if @@ERROR!=0
                              Begin
                                    return -1
                             END
0
Comment
Question by:dotnet0824
2 Comments
 
LVL 19

Accepted Solution

by:
Rimvis earned 1000 total points
ID: 20055768
Hello dotnet0824,

Take a look here:

More about Stored Procedures using ASP.NET 2.0 with the Microsoft Data Access Application Block
http://www.aspfree.com/c/a/ASP.NET/More-about-Stored-Procedures-using-ASPNET-20-with-the-Microsoft-Data-Access-Application-Block/1/


Regards,

Rimvis
0
 

Expert Comment

by:subhorachana
ID: 24308647
Hello,
Were you able to find a way to get the return parameter from Stored procedure using enterprie library 3.1?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question