Problem Returning Two Values From Stored Procedures

Hi, i am trying to return two values from SQL 2000 using a single stored procedure. The stored working fine in Query Analyser and returns the two values and two grids in the results window.





My problem is that when i execute the stored procedure using ADO.Net the dataset only has one of the values. e.g TId : 2, where it should read 'TId' : 2, 'ConfigPath': 'C:lah'





Please could anyone shed ligth on this problem?





here the code for the stored procedure:





CREATE PROCEDURE dbo.GetTillInfo


(


@TillIdR varchar(50),


@Password varchar(50)


)


AS





declare @TillId int


declare @configpath varchar(150)





IF Exists (SELECT Id FROM Tills WHERE TillRef=@TillId and TillPassword=@Password)


BEGIN





set @TillIdR = (SELECT Id FROM Tills WHERE TillRef=@TillId and TillPassword=@Password)


select @TillIdR as 'TId'





set @configpath = (SELECT configpath from customer,tills where


tills.customerid = customer.id and tills.id = @login)


select @configpath as 'ConfigPath'


END


ELSE


BEGIN


set @TillIdR = 0


select @TillIdR as 'TId'


set @configpath =''


select @configpath as 'ConfigPath'


END


GO