stored procedure null problem

[jcisco]

I'm having a problem passing in null values to a stored procedure. can someone please point out where i'm going wrong with this.

--Procedure def
CREATE PROCEDURE sp_rptbl_Fill
@inDate SmallDateTime,
@sDate smalldateTime,
@eDate smalldateTime

--VB solution
SqlConnection1.Open()
SqlCommand1.Parameters("@inDate&quot.Value = Me.Calendar1.SelectedDate
SqlCommand1.Parameters("@sDate&quot.Value = nothing
SqlCommand1.Parameters("@eDate&quot.Value = nothing
SqlCommand1.ExecuteNonQuery()
SqlConnection1.Close()

--Here is the err i'm getting
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

thanks
john

--------------

 

[jcisco]

sorry solved my own problem i needed to use
System.DBNull.Value

--------------