I created a method with the following signature:
public bool CheckEmployeeRegistrationNo(string registrationNo, DateTime timeIn, int createdBy,
DateTime createdDate, int updatedBy, DateTime updatedDate)
{
ClsDatabaseManager dbManager = ClsDatabaseManager.InitializeDbManager();
dbManager.CreateParameters(9);
dbManager.AddParameters(0, "@RegistrationNo", registrationNo);
dbManager.AddParameters(1, "@CreatedBy", createdBy);
dbManager.AddParameters(2, "@CreatedDate", createdDate);
dbManager.AddParameters(3, "@UpdatedBy", updatedBy);
dbManager.AddParameters(4, "@UpdatedDate", updatedDate);
dbManager.AddParameters(5, "@TimeIn", timeIn);
dbManager.AddParameters(6, "@Name", EmployeeName, System.Data.ParameterDirection.Output);
dbManager.AddParameters(7, "@GeneratedTimeIn", GeneratedTimeIn, System.Data.ParameterDirection.Output);
dbManager.AddParameters(8, "@ImageUrl", ImageUrl, System.Data.ParameterDirection.Output);
int result = -1;
try
{
dbManager.Open();
result = dbManager.ExecuteNonQuery("usp_EmployeeCheckRegNo");
if (result > 0)
{
EmployeeName = dbManager.Parameters[6].Value.ToString();
GeneratedTimeIn = dbManager.Parameters[7].Value.ToDate();
ImageUrl = dbManager.Parameters[8].Value.ToString();
}
dbManager.Dispose();
}
catch (Exception ex)
{
dbManager.Dispose();
throw ex;
}
return (result != -1);
}
While my stored procedure is being stored;
ALTER PROC [dbo].[usp_EmployeeCheckRegNo]
(
@RegistrationNo nvarchar(50),
@TimeIn Datetime,
@CreatedBy INT,
@CreatedDate datetime,
@UpdatedBy INT,
@UpdatedDate datetime,
@Name nvarchar(50) OUT,
@GeneratedTimeIn datetime OUT,
@ImageUrl nvarchar(100) OUT
)
AS
BEGIN
if Exists
(
select RegistationNo
FROM [Employe].Registration
WHERE [RegistationNo] = @RegistrationNo
)
BEGIN
INSERT INTO [Employe].[Attendance]
(
RegistrationNo,
[TimeIn],
[CreatedBy],
[CreatedDate],
[UpdatedBy],
[UpdatedDate]
)
VALUES
(
@RegistrationNo,
@TimeIn,
@CreatedBy,
@CreatedDate,
@UpdatedBy,
@UpdatedDate
)
SET @Name = (select er.Name FROM [Employe].[Registration] er
WHERE er.[RegistationNo] = @RegistrationNo);
SET @GeneratedTimeIn = (select a.TimeIn
FROM [Employe].Attendance a
WHERE a.RegistrationNo = @RegistrationNo);
SET @ImageUrl = (select er.[Image]
FROM [Employe].[Registration] er
WHERE er.RegistationNo = @RegistrationNo);
END
ELSE
return 0
END
However, when I enter 2323 (value) in the text box and click the button (on .aspx), I get an error message. I am also debugging a visual studio.
Error;
Line [6]: the size property has an invalid size 0
Why am I getting this error in String 6?
Note. I am currently supplying null values to parameters 6, 7, 8, because they are returned as output.

While on the sql server, I start the stored procedure and display the expected results;
