I am trying to run a stored procedure off an MSDE setup on my computer. Using VS.NET I can actually run the stored proc and see my results and my ouput parameters. Yet when I put it into VB code and try to see it nothing comes up. I still can't figure out if there is a miscommunication between MSDE and my VB app or what is going on.

here is the code that i am using to called the stored proc and everything. The stored proc takes one input parameter and returns multiple result sets and an output parameter

Dim temp As String
        Dim parm1, parm2 As SqlParameter
        Dim TableNames() As String

        parm1 = New SqlParameter("@YearXX", SqlDbType.VarChar, 4)
        parm1.Direction = ParameterDirection.Input
        parm1.Value = "03"
        SelectCmd.Parameters.Add(parm1)

        parm2 = New SqlParameter("@ValidMonths", SqlDbType.VarChar, 250)
        parm2.Direction = ParameterDirection.InputOutput
        parm2.Value = "NA"
        SelectCmd.Parameters.Add(parm2)


        SelectCmd.CommandText = "[LoadDB]"
        SelectCmd.ExecuteReader()

        temp = SelectCmd.Parameters("@ValidMonths").Value()
        MessageBox.Show(temp)

Thank you in advance for the help

Matt

Output parameters are not available until you have read all the resultsets first.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com