Store Procedure return values to VB.net app

[Guest]

Hello All!

I have a SP that returns a int value as an alias called "returnvalue". I can
call the SP fine in my code.
conLog = New
SqlConnection("Server=localhost;uid=*****;pwd=*****;database=footbet")
cmdLog = New SqlCommand("loginStore", conLog)

cmdLog.CommandType = CommandType.StoredProcedure
cmdLog.Parameters.IndexOf("@InUse")
conLog.Open()
cmdLog.ExecuteScalar()
myMainfrm.Show()

conLog.Close()

No I can look at my dataAdapter and preview my return value from my store
procedure. So I believe the connection is just fine. I just want to be able
to send that returnvalue to a text box in my program. So all I need is the
output the SP is giving me, and put that value in a textbox.
Can anybody point me in the right direction, and let me know what is the
best way of doing this?

As always, Thank you for your time.

Rudy

 

[Cor Ligthert]

Rudy

Do you mean?

\\\
mytextbox.Text = cmdLog.ExecuteScalar()
///

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

I hope this helps

Cor

 

[Sahil Malik]

Rudy,

Here is a slightly better link -
http://support.microsoft.com/kb/308049/EN-US/#3
Even though the above would work, you can also do an output parameter from
the s/proc.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Robbe Morris [C# MVP]]

The last ADO.NET code sample shows how to return @RETURN_VALUE

http://www.eggheadcafe.com/articles/20030729.asp

 

[Guest]

Thank you all, you have been very helpful!
I had no idea could be so straight forward. Jeeeze!!
Thanks again for your time!!!

Rudy