How to get multiple values from stored procedure called by DataSet RRS feed

  • Question

  • Hi.

    I am using the procedure below:

    ALTER PROCEDURE [dbo].[hi](@cid int) AS DECLARE @return_value1 int ; DECLARE @return_value2 nvarchar(4000);

    select @return_value1=dbo.Category.MainCatID,@return_value2=dbo.MainCategory.FullName

    from dbo.MainCategory inner join dbo.Category on dbo.MainCategory.ID=dbo.Category.MainCatID where dbo.Category.ID=@cid select @return_value1 as 'Code',@return_value2 as 'Name'

    I calling the procedure from TableAdapter in DataSet, But i cant get more than one value. i can only getback the

     first returned value. 

    I tried by Output parameters but i cant get value from them too.

    Help me, Thanks.

    • Edited by ASP.NET, DEV Saturday, November 17, 2012 10:12 AM
    Friday, November 16, 2012 3:19 PM