William
Sat Apr 24 17:44:44 CDT 2004
Chris:
What you say it doesn't recognize "it", what It are you referring to, the
parameter, the web service, the method or the proc itself. The way it
essentially works from the PPC is that the web service is in charge or
calling the proc. So if the WS calls a stored procedure that needs a
parameter(s), then it ultimately has to build the SqlCommand (since you are
using Sql Server) and add the paramters to it then make the call and return
the results. All the PPC needs to do is send values to the WS so it can use
those values to populate the params with in order to successfully fire the
proc.
Where do you think your problem is? Namely, are you confident that you can
invoke a web service (therefore the likely problem is getting the data to
and from it). Have you created the web reference already and built the
proxy? The only reason I ask is your statement about the WSDL and ADO.NET.
Technically, ADO.NET is only involved client side. You dont have a
dataadapter or anything like that. All you do is pass your dataset to the WS
and it handles that, and you pass params to the WS and it returns a dataset.
So IT takes care of all the datahandling...technically, if you use a WS for
all of your dataaceess, you'll have a datatable or a dataset client side,
but you won't have any command objects or connections.
As far as do you need a WSDL, the answer is that you need something.. I
don't know the web service but something has to be used to build the proxy.
Hvae you gotten this far? have you added your web reference? Basically,
can you tell me what all you've done and where specifically the problem is?
I've done more with web services than anything else and am writing an in the
process of writing an article on Invoking Google's web service with
SmartPhone 2003.... definitely have some experience with invoking WS via
devices and will do my best to help .
Let me know and I'll do what I can.
Cheers,
bill
"Chris Rose" <crose_nl@yahoo.com> wrote in message
news:O$sn6ljKEHA.3392@TK2MSFTNGP10.phx.gbl...
> I've written a very basic web service that is used by my PocketPC to add
two
> numbers together. It works fine. So next I'm writing a WebService which
> accesses my SQL Server
> and returns rows appertaining to a specific OrderId.
>
> I have written a stored procedure called spGetConfirmedOrder to which I
pass
> the OrderId and it works okay until I need to reference it in my code then
> it doesn't recognise
> it. Is there something that I'm missing out here do I need to get involde
> with SOAP and WDSL files
> or can I just use ADO.NET?
>
> Regards
>
> Chris
>
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (
http://www.grisoft.com).
> Version: 6.0.667 / Virus Database: 429 - Release Date: 23/04/2004
>
>