Web Services

Re: Creating a web service

Stavi — Thu, 14 Sep 2006 12:53:11 GMT

Ok, I need help now.

I have got the hang on using a sqlDataAdapter to create a DataSet with 1 table and a parameter to return one record

I have also got the hang of using several sqlDataAdapter's to create a DataSet with related tables (nested) returning all records

What I cannot work out how to do is to filter parent table by primary key (return one record) then have child tables return only related records

Sorry if thats not very clear, I am teaching myself from scratch here ;)

I have done this using the designer and wizards in vs2006, the only code i have had to type is

[WebMethod]
public DataSet workdammit(@inputID) {
daSelectCommand.Parameters["@ID"].value = @inputID
da.Fill(ds);
return ds;}

or

[WebMethod]
public DataSet workdammit() {
daName.Fill(ds); //repeat for each related da
return ds;}

Re: Creating a web service

Stavi — Wed, 30 Aug 2006 15:10:19 GMT

I did it! data I submitted appeared in the database :) thats select, update, insert and delete dealt with :)

Re: Creating a web service

Stavi — Wed, 30 Aug 2006 14:00:12 GMT

So far I have got Infopath to say "Hello World" via a web service :)

I have also got Infopath to convert temperatures via a web service :)

And believe it or not I have got Infopath to display data from my database via a web service :)

Now I have got to work out how to submit data back again,, my heads hurts

Re: Creating a web service

Stavi — Mon, 21 Aug 2006 10:41:45 GMT

Thank you, that's exactly what I wanted

Looks like I got a few weeks of learning to do :)

Re: Creating a web service

BonsaiGuy — Fri, 18 Aug 2006 16:42:59 GMT

good starting place

http://msdn2.microsoft.com/en-us/library/87h5xz7x.aspx

Creating a web service

Stavi — Thu, 17 Aug 2006 12:13:32 GMT

I have been trying to teach myself about web services

I have read several articles on the MSDN website about creating a web service using vs2003, however i am using vs2005 and have not been able to try any of it

Does anyone know where I can find basic info on web services and vs2005?