Stored Procedure Return Values

[Adam Knight]

Hi all,

I am wanting to get a stored procedure return value via ADO.NET..

Code: Below:

 

[Adam Knight]

Stupid computer!!!

'sp to insert
cmdInsertContractor = New SqlCommand("ins_cntr_mgt_contractor", Conn)
cmdInsertContractor.CommandType = CommandType.StoredProcedure
cmdInsertContractor.Parameters.Add(New SqlParameter("@mid",
Trim(Session("MID"))))
cmdInsertContractor.Parameters.Add(New SqlParameter("@company",
Trim(txtCompany.Text)))
cmdInsertContractor.Parameters.Add(New SqlParameter("@first_name",
Trim(txtFirstName.Text)))
cmdInsertContractor.Parameters.Add(New SqlParameter("@last_name",
Trim(txtLastName.Text)))
cmdInsertContractor.Parameters.Add(New SqlParameter("@email",
Trim(txtEmail.Text)))
cmdInsertContractor.Parameters.Add(New SqlParameter("@mobile",
Trim(txtMobile.Text)))
cmdInsertContractor.Parameters.Add(New SqlParameter("@phone",
Trim(txtPhone.Text)))
cmdInsertContractor.Parameters.Add(New SqlParameter("@position",
Trim(txtPositionHeld.Text)))
cmdInsertContractor.Parameters.Add(New SqlParameter("@ctype",
Trim(rbtnContractorType.SelectedValue)))

What do i need to add to create a return value parameter?

Cheers,
Adam

 

[Guest]

Adam,

try adding the following code:

Dim returnValue as SqlParameter = New SqlParameter()
returnValue.Direction = ParameterDirection.ReturnValue
cmdInsertContractor.Parameters.Add(returnValue)
' Execute sp here
' After execution, you can read the returncode from returnValue
Console.WriteLine(string.Format("ReturnValue: {0}", returnValue.Value))

check out
http://msdn.microsoft.com/library/d...ml/cpconinputoutputparametersreturnvalues.asp (watch line-wraps) for more info...

HTH,
Baileys

 

[Patrick.O.Ige]

Adam there are more samples here at:-
http://www.developerfusion.co.uk/show/4278/3/
Patrick

Adam,

try adding the following code:

Dim returnValue as SqlParameter = New SqlParameter()
returnValue.Direction = ParameterDirection.ReturnValue
cmdInsertContractor.Parameters.Add(returnValue)
' Execute sp here
' After execution, you can read the returncode from returnValue
Console.WriteLine(string.Format("ReturnValue: {0}", returnValue.Value))

check out

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconinputoutputparametersreturnvalues.asp (watch line-wraps) for more
info...