Stored procedure always returns -1 in c# RRS feed

  • Question

  • I designed the procedure to return 1 if ok, 0 if error. My procedure is always returning -1 in my code.

    If I use data from one of the inputs and test it in the preview data in the dataset in my project it correctly returns 1.

    in my code to get the value returned I am saying.

    int x = QueriesTableAdapter.mySP(params)

    then checking to see what x is and handling it.

    Am I doing the call incorrectly? Help?

    Friday, January 8, 2010 1:53 PM

All replies

  • When you created the TableAdapter using the TableAdapter Query Configuration Wizard did you select the option to return a single value?
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Monday, January 11, 2010 1:27 PM