Error On Passing Parameter To Stored Procedure

Hi,





I have a procedure that will save to table in sql server 200 via stored procedure. When I hit the save button it alwasy give me an error saying "Procedure 'sp_AddBoard' expects parameter '@dtmWarrantyStart', which was not supplied" even though I supplied it in the code





which is





Dim ParamdtmWarrantyStart As SqlParameter = New SqlParameter("@dtmWarrantyStart", SqlDbType.datetime, 8)


ParamdtmWarrantyStart.Value = dtmWarrantyStart


myCommand.Parameters.Add(ParamdtmWarrantyStart)





below is the stored procedure.





create Proc sp_AddBoard(@BrandID int,


@strPcName varchar(50),


@bitAccounted bit,


@dtmAccounted datetime,


@dtmWarrantyStart datetime,


@dtmWarrantyEnd datetime,


-- @strDescription varchar(500),


@intStatus int,


@ModelNo varchar(50),


@intMemorySlots int,


@intMemSlotTaken int,


@intAgpSlots int,


@intPCI int,


@bitWSound bit,


@bitWLan bit,


@bitWVideo bit,


@dtmAcquired datetime,


@stat bit output,


@intFSB int) as


if not exists(select strPcName from tblBoards where strPcName=@strPcName)


begin


insert into tblBoards


(BrandID, strPcName, bitAccounted,


dtmAccounted, dtmWarrantyStart,


dtmWarrantyEnd, --strDescription,


intStatus,


ModelNo, intMemorySlots, intMemSlotTaken,


intAgpSlots, intPCI, bitWLan,


bitWVideo, dtmAcquired,intFSB,bitWSound)





values





(@BrandID,@strPcName,@bitAccounted,


@dtmAccounted,@dtmWarrantyStart,


@dtmWarrantyEnd,--@strDescription,


@intStatus,


@ModelNo,@intMemorySlots,@intMemSlotTaken,


@intAgpSlots,@intPCI,@bitWLan,


@bitWVideo,@dtmAcquired,@intFSB,@bitWSound)


end


else


begin


set @stat=1


end





The table is also designed to accept nulls on that field but still same error occured.





Please help