Web service on two tables

[garyrob]

Please could anyone show me how to create a web service which accesses and
updates information in two tables. I have seen examples in MSDN based on one
table but these fail when using the DataAdapter Config Wizard tries to join
two tables.

Many thanks

[Cor Ligthert]

Gary,

In my opinion will this always fail, it is not depending on the webservice.

I searched for some messages, this one (and the thread) looked for me one
who gives an idea,

http://groups-beta.google.com/group/...8476857ca1c062

I hope this helps

cor

[Miha Markic [MVP C#]]

Why don't you create sql statements and code by yourself?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"garyrob" <ga*****@discussions.microsoft.com> wrote in message
news:89**********************************@microsof t.com...

Please could anyone show me how to create a web service which accesses and
updates information in two tables. I have seen examples in MSDN based on
one
table but these fail when using the DataAdapter Config Wizard tries to
join
two tables.

Many thanks

[garyrob]

Hi

Thanks very much both of you. Cor I am looking at your solution. Miha I am
new to the whole scene, I know I should know more about it. I started with
this because I am doing an InfoPath project. I didn't realise it would throw
me so deeply into Ado.net, etc.

I am trying to get up to speed. I have hunted quite extensively for a simple
solution. SQL is fine. If I can get an example of a web service with
interacts with two joined tables on Northwind I can figure the rest out. A
lot of the walkthroughs deal with a single table.

Any help would be appreciated.

"Miha Markic [MVP C#]" wrote:

Why don't you create sql statements and code by yourself?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"garyrob" <ga*****@discussions.microsoft.com> wrote in message
news:89**********************************@microsof t.com...

Please could anyone show me how to create a web service which accesses and
updates information in two tables. I have seen examples in MSDN based on
one
table but these fail when using the DataAdapter Config Wizard tries to
join
two tables.

Many thanks