Jump To VB.NET

CREATE PROCEDURE usp_WoojjaReturnValue
(
     @WoojjaName NVARCHAR(50),
     @WoojjaValue INT
) AS

-- INSERT the new record
INSERT INTO woojjaTable(Name, Value)
VALUES(@WoojjaName, @WoojjaValue)

RETURN 1

Dim woojjaConnection as New SqlConnection(connection string)
woojjaConnection.Open()

Dim woojjaCommand as New SqlCommand("usp_WoojjaReturnValue", woojjaConnection)
woojjaCommand.CommandType = CommandType.StoredProcedure

woojjaCommand.Parameters.Add("@WoojjaName", SqlDbType.VarChar, 50)
woojjaCommand.Parameters("@WoojjaName").Value = userID
woojjaCommand.Parameters.Add("@WoojjaValue", SqlDbType.Int)
woojjaCommand.Parameters("@WoojjaValue").Value = siteID

'여기서부터가 중요하다.
Dim returnValParam as New SqlParameter("@RETURN_VALUE", SqlDbType.Int)

'요기가 젤루 중요하다. ParameterDirection 을 ReturnValue 로 해야한다는거
returnValParam.Direction = ParameterDirection.ReturnValue

'그리고 마지막으로 Parameters Collection 에 parameter 를 추가한다.
woojjaCommand.Parameters.Add(returnValParam)

Dim woojjaReader as SqlDataReader = woojjaCommand.ExecuteReader()

Dim returnValue as Integer = Convert.ToInt32(returnValParam.Value)