I have an asp.net web service I used for all my asp.net forms. I would like to use the same service for pdf forms. I have a test method which takes no parameters and sends an email. This works fine. Can I use a method which returns a dataset and if yes how? I tried the following code but get an error, oItems has no properties. How do I get values out of a dataset?
SOAP.wireDump = false;
var oListURL = "https://ao-wapps/webservices.asmx?wsdl";
PDF Forms only support simple types through a web service (i.e. strings, int, float, xml wrapped in CData as examples). There is no container to hold the recordset hence it does not know what to do with the return.
If the DB can return XML then you can do that (wrap it in a CData section or the SOAP envelope will get confused). If not then returning a record at a time and assigning each column to a variable is also an option.