change your sp Like this..

CREATE PROCEDURE dbo.AddNewRec

(

@T_CID int,

@T_DeadLine int

)

AS

INSERT INTO tblRequest

(

T_CID,

T_Date,

T_DeadLine

)

VALUES

(

@T_CID,

GETDATE(),

DateAdd(n,30,GETDATE() )

)

GO

IN VB do the Following Steps

1) Create a Connection...