Stored Proc Syntax Error?

Can anyone see an error here? I am getting a general exception when call this and it is driving me crazy. What am I missing? The error is.....{"Incorrect syntax near 'UpdateStaffDept'." ... Any help is greatly appreciated! Below is the code calling the proc

Thank you!

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[UpdateStaffDept]

@Co_Id INT,

@CardNo VARCHAR(50),

@DeptNo VARCHAR(50)



AS

SET NOCOUNT ON



DECLARE

@Error INT



SELECT @Error = @@Error

IF @Error = 0

BEGIN



BEGIN TRANSACTION

UPDATE Staff

SET Dept_No = @DeptNo

WHERE Co_Id = @Co_Id

AND PC_Id IN (SELECT PC_ID FROM PC_Number WHERE PC_Number = @CardNo)



SELECT @Error = @@Error

IF @Error <> 0

BEGIN

ROLLBACK TRANSACTION

RETURN @Error

END

ELSE

COMMIT TRANSACTION



END

 

Dim seldeptno As String

seldeptno = ddlEditPosDept.SelectedValue

Dim cmdChnDept As SqlCommand

cmdChnDept = New SqlCommand("UpdateStaffDept", conEditPos)

cmdChnDept.Parameters.Add(New SqlParameter("@Co_Id", SqlDbType.Int 10))

cmdChnDept.Parameters("@Co_Id").Value = compid

cmdChnDept.Parameters.Add(New SqlParameter("@CardNo", SqlDbType.VarChar, 50))

cmdChnDept.Parameters("@CardNo").Value = lblEditPosCardNo.Text

cmdChnDept.Parameters.Add(New SqlParameter("@DeptNo", SqlDbType.VarChar, 50))

cmdChnDept.Parameters("@DeptNo").Value = seldeptno

cmdChnDept.ExecuteNonQuery()