My solution is to alter your stored procedure..
ALTER PROCEDURE [dbo].[SelectUserPassExist]
@Usr varchar,
@Pass varchar
AS
BEGIN
Print @Usr -- Will only prompt first character
Print @Pass -- Will only prompt first character
if not exists( select FirstName,LastName from [User] where (FirstName=@Usr and LastName=@Pass))
Begin
return -3
end
else
Begin
return 2
end
end
Alter to f.ex
ALTER PROCEDURE [dbo].[SelectUserPassExist]
@Usr varchar(max), -- To allow more than one character
@Pass varchar(max) -- To allow more than one character
if not exists( select FirstName,LastName from [User] where (FirstName=@Usr and LastName=@Pass))
Begin
return -3
end
else
Begin
return 2
end
end