Public Sub FillByDate(ByVal ldDate As Date)

Dim loCommand As New SqlCommand()

loCommand.CommandText = "Select * from Library where Media_date BETWEEN @ldMediaDate AND @ldMediaDatePlusOneDay"

loCommand.Parameters.Add("@ldMediaDate", SqlDbType.DateTime)

loCommand.Parameters("@ldMediaDate").Value = ldDate.Date

loCommand.Parameters.Add("@ldMediaDatePlusOneDay", SqlDbType.DateTime)

loCommand.Parameters("@ldMediaDatePlusOneDay").Value = ldDate.Date + New TimeSpan(1, 0, 0, 0)

Me.FillDataTable(loCommand)

End Sub

If I were using VFP I would use ttod(Media_date) = ctod('10/15/2006').

The Problem I am having is I don't get a record back.  Eventhough I know that date is there.

Below is my Method

I am using SQLExpress and I have a table called Library.  I have a BO call Library1.  I created a method called FillByDate.

The column on my table that I want to look at is media_date it is of DataType DateTime.

my SQL is: "Select * from library where Media_date = @ldDate"

 ldDate = cdate("10/15/2006")

I am also new to Sql Server so My Question is what date conversion function do I need to get my parameter and my Table.DateTime Field to work. 

PS, I don't know what the actual time would be...Just the Date