ALTER PROCEDURE dbo.INSERT_USER
@UserName varchar(50),
@FirstName varchar(50),
@LastName varchar(50),
@Password varchar(50),
@Email varchar(50),
@LastLogIn datetime,
@CreatedBy varchar(50),
@MSG VARCHAR(10) OUT,
@CreatedOn datetime,
@active varchar(50)
AS
BEGIN
BEGIN TRY
INSERT INTO Users
(UserName,FirstName,LastName,Password,Email,LastLogIn,CreatedBy,CreatedOn,Active
)
VALUES (
@UserName,
@FirstName,
@LastName,
@Password,
@Email,
GETDATE(),
@CreatedBy,
GETDATE(),
1
)
SET @MSG='SUCCESS'
END TRY
BEGIN CATCH
SET @MSG = 'FAILED'
END CATCH
END
this is the new query of yours try this this will work the thing is your both c# and sql parameters must be matched :)