Data Connections

Re: submitting data to a web service

MashadaG — Tue, 28 Jul 2009 09:30:12 GMT

I have figured what to do, just in case anyone else has a similar problem.

Use the submit data as string option in the data connections bit. This will submit an XML string that can then be transformed into a dataset in the web service, use a signature as below e.g.

<WebMethod()> _

Public Function SaveRpt(ByVal cls As String)

Dim ds1 As New DataSet

Dim tr As TextReader = New StringReader(cls)

Dim xr As XmlReader = New XmlTextReader(tr)

ds1.ReadXml(xr)

Dim rr As DataRow

strMsg = ds1.Tables.Count

For Each rr In ds1.Tables("tbl").Rows

strMsg = strMsg & " *** " & rr.Item("item1").ToString

Hope this helps someone as it has driven mne up the wall for a while :)

Re: submitting data to a web service

MashadaG — Wed, 22 Jul 2009 08:26:17 GMT

Patrick

Thanks for your response. I am trying to achieve the most basic of things I believe but I have no clue as to how to proceed. Consider this a customer and orders example. The relationship is one to many respectively. This means that the orders bit will be in a repeating table on the form say. Now retrieving that info via a web service is quite straight-forward as I will create a web method that returns an XML document.

What I am struggling with is the submit method. Say I create a web method called SaveRecords(), I am not sure what parameters to pass to it for me to then access the data that is returned from the InfoPath form. What I want to do is to access the data returned and do some calculations e.g. add VAT then submit this to a stored procedure. I believe the web method should be something like SaveRecords (ByVal Obj as ObjType), what I am not sure is what should ObjType be? Is it a class, enum??? That's what I do not understand.

That said I will try out your web service.

Thanks for the help

Re: submitting data to a web service

Patrick Halstead — Tue, 21 Jul 2009 19:37:13 GMT

Hi MashadaG and welcome to our forum!

I don't understand your post. It seems like you are doing something in a way that is way too complicated, but it's also possible that I am just confused because I don't understand your scenario very well.

What I will recommend is to install our free Web Service trial. I guarantee you'll be able to receive and submit data to SQL 2005 in very little time (certainly shouldn't take more than an hour or two to install, configure and have working). That may be an option for you. We can give you an extended trial if you want it. Might be a good stopgap to get your stuff working and then you'll have more time to debug your custom Web Service. I'm not trying to get you to buy anything but rather just trying to offer a free alternative to get unblocked so that you can show your solution working, etc.

submitting data to a web service

MashadaG — Tue, 21 Jul 2009 16:42:38 GMT

I am new to InfoPath 2007 and I am working on a live project that requires its use asap. I require to retrieve and submit data via a web service (SQL2005) that I have written in VB.NET. The retrieval part works fine but my main problem is with the submit part. What I am confused is what the signature for the submit method should be like. After I receive the data, I need to do some internal biz process calculations before I persist it in the database

This is how I am retrieving the data. That works well and returns an xml document in place of a dataset as that is not supported. <WebMethod()> _Public Function GetAllRecords(ByVal acad_period As String, ByVal aos_code As String, ByVal aos_period As String) As System.Xml.XmlDocument This is how I am retrieving the data (this is the difficult part that I cannot understand). What signature do I use for the web service that receives the submitted data. For instance how do I get the values in the controls as if these are submitted back, they must exist in some type of object. That is what I do not understand. <WebMethod()> _ Public Function SaveRec() As String

I would appreciate any help or pointing in the right direction, this has really been nagging me all week :(