Web service on two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
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 said:
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
 
Back
Top