locked
Stored Procedure returning multiple rows RRS feed

  • Question

  • I have a stored procedure which return a single value and one which return multiple rows between two colums.
    In my code for the procedure which returns a single value i use (executescalar) which works fine.
    I am not sure what command to use in my code when i am calling the stored procedure that returns multiple rows between colums.
    Any help would be appreciated.
    Thanks.
    Tuesday, October 23, 2007 5:42 PM

All replies

  • Use ExecuteReader... Google it "DataReader" & "Data Set"

    Tuesday, October 23, 2007 6:17 PM
  • Thanks.
    Tuesday, October 23, 2007 6:21 PM
  • Yes. Exceute Scalar returns -1. 0, or 1

     

    Adam

    Wednesday, October 24, 2007 4:10 AM