Get return code from a stored procedure using c# [duplicate]

Question

I have a return code from a stored procedure that I need to verify. I can't change the proc because it is part of a vendor package. Changing it to an output parameter is not possible. I don't care so much about the parameters as capturing the return code in c#. Here is an example of what I'm trying to do: Procedure:

create proc tester
   @parm nvarchar(3)
as

if @parm = 'Yes'
       return 1
else
       return -1
go

C# sample code:

SqlConnection sqlMon = new SqlConnection("Whatever");

sqlMon.Open();
SqlCommand sqlcomm = new SqlCommand("tester", sqlMon);
SqlDataReader sqlR; 
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.Add(new SqlParameter("@parm", "Yes"));

sqlR = sqlcomm.ExecuteReader();

sqlMon.Close();

What I can't figure out is how do I now get the return code. Any help you can provide is appreciated. Thanks.

coder231 · Accepted Answer · 2015-06-15 19:36:33Z

2

You can add a new parameter as below.

    SqlParameter ret = sqlcomm.Parameters.Add("@R", SqlDbType.Int);
    ret.Direction = ParameterDirection.ReturnValue;
    string returnvalue = (string)sqlcomm.Parameters["@R"].Value;

answered Jun 15, 2015 at 19:36

coder231

4632 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

scot davenport Over a year ago

This worked. I had to add the return code as the first parameter. Than you!

Community · Accepted Answer · 2017-05-23 12:05:59Z

0

ExecuteReader() returns a SqlDataReader:

SqlDataReader dr = sqlComm.ExecuteReader();

You can then work with the SqlDataReader to bind the data to a control, or whatever else you'd like to do.

https://msdn.microsoft.com/en-us/library/9kcbe65k(v=vs.110).aspx

Here is an example of how to bind a DataReader to a GridView:

Binding sqldatareader to gridview c#

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Jun 15, 2015 at 19:32

maniak1982

7172 gold badges7 silver badges23 bronze badges

Collectives™ on Stack Overflow

Get return code from a stored procedure using c# [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related