I have a stored procedure as follows:


(@PatientID as varchar, @dateIn as datetime)
AS
SELECT
    MriPatients.PatientID AS PatientID,
    MriPatients.Name AS Name,
    SchAppointments.Status AS Status,
    SchAppointments.AppointmentTypeID AS AppTypeID,
    SchAppointments.TypeDescription,
    SchAppointments.DateTime,
    SchAppointments.VisitID,
    SchEncounterForm.[Encounter Form],
    SchEncounterForm.Description
FROM
    MriPatients INNER
JOIN
    SchAppointments ON
        MriPatients.SourceID = SchAppointments.SourceID AND
        MriPatients.PatientID = SchAppointments.PatientID INNER JOIN
        SchEncounterForm ON SchAppointments.AppointmentTypeID = SchEncounterForm.[Appt Type]
WHERE
    (MriPatients.PatientID = @PatientID) AND
    (SchAppointments.Status = 'BOOKED') AND
    (CONVERT(char(10) , SchAppointments.DateTime , 101) = @dateIn)

This Procedure should return one row for a patient Appointment. In Query analyzer the query runs as expected and returns one row. In the VS IDE using Servr Explorer no rows are returned. Does anyone know why this wont work in Server Explorer. I suspect it is something simple like a dataType but I am only using two parameters.

I ran a breakpoint in the SP and it is not the procedure that is failing.
 Here is the code that calls the SP:

Dim tmpCMD As New SqlCommand("PatientFormsByPatientID", DRSPLAT)
            Dim appDate As String = Convert.ToDateTime(EncounterForm.dateIN).ToString( "MM/dd/yyyy")
            Dim tmpDS As New DataSet
            With tmpCMD
                .CommandType = CommandType.StoredProcedure
                .Parameters.AddWithValue("@PatientID", PatientID)
                .Parameters.AddWithValue("@datein", appDate)
                .Parameters(0).Direction = ParameterDirection.Input
                .Parameters(1).Direction = ParameterDirection.Input
            End With
            Dim tmpDA As New SqlDataAdapter(tmpCMD)
            tmpDA.Fill(tmpDS) 'Aborts here

as you can see, the fill method of the Dataadapter is where the logic error is, and the adapter never fills, even though the SP returns 1 row.

Ok I found the problem... if anyone cares

The parameter i was calling the SP with was not the same as in the SP .

this was the culprit line of code:
  .Parameters.AddWithValue("@datein", appDate)
 should have been "@dateIn"

always the little things...