DarleenVanliewp
New Member
i have this stored procedure in my DataBase:\[code\]Select something From somewhere Where Id = @Id And Category in (Select carId From CarCategory where..)\[/code\]when i test this stored procedure in the Visual Studio Execute it works just fineBut When i call my web service function that uses this procedure it doesn't give me any results (the DataSet retrieved is empty)so i had no choice but to rewrite the stored procedure in like this:\[code\] Select somthing From somewhere Where Id = @Id And Category = @Category\[/code\]But that isn't what i really want i want the previous method to function.more info on this problem:I think that the remote server can't access the CarCategory table to get the data,,, is that possible??because when i use another stored procedure to call a function that call a another procedure to get info from CarCategory it doesn't work and send me an error.Why cant the server find any row,, there is plenty of rows should be retrieved it is really annoying, i cant figure out why can any one help??????????????this error is:\[code\]System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.IndexOutOfRangeException: There is no row at position 0. at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at System.Data.DataRowCollection.get_Item(Int32 index) at Selling_Agency.categoryNameToID(String Name) in e:\from moaaz\WEB SERVICES\carBroker_SellingAgency1\App_Code\Selling_Agency.cs:line 68 --- End of inner exception stack trace ---\[/code\]