Help Required in SqlHelper.ExecuteNonQuery

  • Thread starter Thread starter RJN
  • Start date Start date
R

RJN

Hi

I want to get the rerurn value from a stored procedure

My stored proc looks like this

create proc test
.....
if..
return 1
else
if ..
return 2
else
..return 0

I'm using the SqlHelper.ExecuteNonQuery and pass the procedure name,
connection and an array of parameters. How I do I get the return value
from this. If I create a parameter of Diretion ReturnValue and include
in the parameter array, I get an error that the parameters don't match.
WHat is the correct way of doing?

Regards

RJN
 
Hi,

Use ExecuteScalar instead.

http://msdn.microsoft.com/library/d...qlclientsqlcommandclassexecutescalartopic.asp

Ken
-------------------------

Hi

I want to get the rerurn value from a stored procedure

My stored proc looks like this

create proc test
.....
if..
return 1
else
if ..
return 2
else
..return 0

I'm using the SqlHelper.ExecuteNonQuery and pass the procedure name,
connection and an array of parameters. How I do I get the return value
from this. If I create a parameter of Diretion ReturnValue and include
in the parameter array, I get an error that the parameters don't match.
WHat is the correct way of doing?

Regards

RJN
 
Use executeScalar to return a ret val. ExecuteNonQuery would be for
something like "set transaction isolation level read uncommitted" or
similar.

hth
Eric
 
Use executeScalar to return a ret val. ExecuteNonQuery would be for
something like "set transaction isolation level read uncommitted" or
similar.
Click to expand...

....or something less exotic like INSERT, UPDATE, or DELETE.
 
Forgot to mention that I'm having update statements in the stored proc
so i can't use ExecuteScalar
 
True, but DML from the front-end is bad practice. Stored procedures should
be the only means of DML.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A value copy, not reference, of SqlParameter? 6
last ditch attempt to try and get this working 5
Entity Framework Return Value from Stored Procedure - Getting Error 1
Still Having SQL Stored Proc probs 1
sp_stored_procedures help 1
Loss of datetime precision when attaching parameters to an ADO.NET command 2
returning multiple values at the same time in a function 16
A function that returns an array of SqlClient.SqlParameter objects 1

Back
Top