Problems retrieving Data using stored procedure in asp.net web service -


i have stored procedure in database:

select somewhere id = @id  , category in (select carid carcategory where..) 

when test stored procedure in visual studio execute works fine

but when call web service function uses procedure doesn't give me results (the dataset retrieved empty)

so had no choice rewrite stored procedure in this:

 select somthing somewhere id = @id  , category = @category 

but isn't want want previous method function.

more info on problem:

i think remote server can't access carcategory table data,,, possible??

because when use stored procedure call function call procedure info carcategory doesn't work , send me error.

why cant server find row,, there plenty of rows should retrieved annoying, cant figure out why can 1 help??????????????

this error is:

system.web.services.protocols.soapexception: server unable process request. ---> system.indexoutofrangeexception: there no row @ position 0.    @ system.data.rbtree`1.getnodebyindex(int32 userindex)    @ system.data.datarowcollection.get_item(int32 index)    @ 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 --- 

check connection string make sure user has.

if uses integrated security / windows authentication, notice web service using asp.net account not account. reason cannot access db. if so, can solve using sql authentication example.


Comments

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -