Help Required in SqlHelper.ExecuteNonQuery

[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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ken Tucker [MVP]]

Hi,

Use ExecuteScalar instead.

http://msdn.microsoft.com/library/de...calartopic.asp

Ken
-------------------------
"RJN" <rj*@yahoo.com> wrote in message
news:u8**************@TK2MSFTNGP10.phx.gbl...

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Eric Sabine]

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

hth
Eric
RJN wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Jeff Johnson]

"Eric Sabine" <mopar41@mail_after_hot_not_before.com> wrote in message
news:e3**************@TK2MSFTNGP15.phx.gbl...

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

....or something less exotic like INSERT, UPDATE, or DELETE.

[Greg Burns]

Jeff Johnson wrote:

"Eric Sabine" <mopar41@mail_after_hot_not_before.com> wrote in message
news:e3**************@TK2MSFTNGP15.phx.gbl...

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

...or something less exotic like INSERT, UPDATE, or DELETE.

LOL

[RJN]

Forgot to mention that I'm having update statements in the stored proc
so i can't use ExecuteScalar
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Eric Sabine]

True, but DML from the front-end is bad practice. Stored procedures should
be the only means of DML.
Jeff Johnson wrote:

"Eric Sabine" <mopar41@mail_after_hot_not_before.com> wrote in message
news:e3**************@TK2MSFTNGP15.phx.gbl...

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

...or something less exotic like INSERT, UPDATE, or DELETE.

[Ken Tucker [MVP]]

Hi,

I guess an output parameter is your only option.

http://support.microsoft.com/default...b;en-us;308049

Ken
---------------
"RJN" <rj*@yahoo.com> wrote in message
news:Oo**************@TK2MSFTNGP10.phx.gbl...

Forgot to mention that I'm having update statements in the stored proc
so i can't use ExecuteScalar
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!