Sp_tblSharedUser_INS' Expects Parameter '@Ids1', Which Was Not Supplied

I've spent many days analyzing this error (sp_tblSharedUser_INS' expects parameter '@Ids1', which was not supplied) and trying to figure it out. If anyone out there can help me, I will be forever grateful.

STORED PROCEDURE

ALTER PROCEDURE sp_tblSharedUser_INS

(@MyId [VarChar](25),

@CreatedBy int,

@DependantIds [VarChar](255),

@Ids1 varchar(255) output

)

AS



Declare @Ids as varchar(255)

declare @separator_position as int

declare @array_value as varchar(20)

declare @Count as int

declare @MaxValue as int

set @Ids=@DependantIds + ','

set @Ids1='0'

set @MaxValue=5

while patindex('%' + ',' + '%' , @Ids) <> 0

begin

select @separator_position = patindex('%' + ',' + '%' , @Ids)

select @array_value = left(@Ids, @separator_position - 1)



select @Count=Count(SharedUserId) from tblSharedUser where DependantIds LIKE ('%,' + @array_value + ',%')







if( @Count< @MaxValue)

begin

set @Ids1 =@Ids1 + ',' + @array_value



end





select @Ids = stuff(@Ids, 1, @separator_position, '')

end

IF NOT @Ids1='0' or @Ids1='0,0'

begin

if not exists(select MyId from tblSharedUser where MyId=@MyId and CreatedBy=@CreatedBy and DependantIds=@DependantIds )

begin



INSERT INTO tblSharedUser

([CreatedBy],

[DependantIds],

[MyId]

)

VALUES(

@CreatedBy,

@Ids1,

@MyId)

RETURN @@identity

end

else

begin

return 0

end

end



else

begin

return -1

end

CODE

insertCommand = New SqlCommand("sp_tblSharedUser_INS", New SqlConnection(Config.cnnstr))

insertCommand.CommandType = CommandType.StoredProcedure

With insertCommand.Parameters

.Add(New SqlParameter(MYID_PARAM, SqlDbType.VarChar))

.Item(MYID_PARAM).SourceColumn = dsSharedUser.MYID_FIELD

.Add(New SqlParameter(CREATEDBY_PARAM, SqlDbType.BigInt))

.Item(CREATEDBY_PARAM).SourceColumn = dsSharedUser.CREATEDBY_FIELD

.Add(New SqlParameter(DEPENDANTIDS_PARAM, SqlDbType.VarChar))

.Item(DEPENDANTIDS_PARAM).SourceColumn = dsSharedUser.DEPENDANTIDS_FIELD

.Add(New SqlParameter("@lngReturn", SqlDbType.Int))

.Item("@lngReturn").Direction = ParameterDirection.ReturnValue

.Add(New SqlParameter("@Ids1", SqlDbType.VarChar, 255))

.Item("@Ids1").Direction = ParameterDirection.Output

End With

dsCommand.InsertCommand = insertCommand

dsCommand.Update(dsSharedUser, dsSharedUser.SHAREDUSER_TABLE)

lngReturn = CType(dsCommand.InsertCommand.Parameters.Item("@lngReturn").Value, Int32)

Ids = CStr(dsCommand.InsertCommand.Parameters.Item("@Ids1").Value)