Error occured: Procedure .. has too many argument specified
I have an issue that when i Update the record there is error "Error occured: Procedure .. has too many argument specified". It is my Store procedure
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[web_usp_empData_Update]
@id bigint,
@Code nvarchar(10),
@Name nvarchar(50),
@Address nvarchar(150),
@Tel nvarchar(20),
@HP nvarchar(20),
@email nvarchar(50),
@NRIC nvarchar(20),
@Jobtitle nvarchar(50),
@Dept nvarchar(20)
As
Begin
Update empData
Set
[Code] = @Code,
[Name] = @Name,
[Address] = @Address,
[Tel] = @Tel,
[HP] = @HP,
[email] = @email,
[NRIC] = @NRIC,
[Jobtitle] = @Jobtitle,
[Dept] = @Dept
Where
[id] = @id
End
My update code
cmd.Connection = conn
cmd.CommandText = ("web_usp_empDa ...
Go to the complete details ...