Graeme,
I get this post if really old, but I looking to do the same thing, submit/retrieve/update to a SQL DB via an infopath form published in Sharepoint. If you can remember, is there any chance you might outline the tasks involved.
I already have the .cs and I have also produced the .asmx file, I think I know have to create a new web method, but I am not sure how to proceed from here. I am using Visual Studio Community and Infopath 2010.
Thank you in advance for any help and advice.
Regards,
Paul.