General

Re: Retrive data after insert.

Patrick Halstead — Wed, 16 Nov 2005 06:39:42 GMT

Yes, you'll want to do Start->InfoPath. The Fill Out a Form dialog will appear. Choose Design a Form in lower left corner and choose New from Data Connection in Task Pane. Then choose Web Service and answer the questions. Should work like a charm.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Retrive data after insert.

franck — Tue, 15 Nov 2005 14:18:50 GMT

Hi,

I think that Patrick suggested a new template, not a new View.

Franck

Re: Retrive data after insert.

mika — Tue, 15 Nov 2005 10:26:53 GMT

quote:
Create a new form from the web method.

How can I do this? New view can create only from task pane.

Re: Retrive data after insert.

Patrick Halstead — Tue, 15 Nov 2005 08:19:46 GMT

Hi again,
Create a new form from the web method. Then you can retrieve and submit. You don't have this option if you try to bind an existing form to a web method via the data connections dialog.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Retrive data after insert.

mika — Mon, 14 Nov 2005 20:00:41 GMT

quote:
If you are confortable with managed code, you can even call a WS from your own code, bypassing the built-in mechanism.

Yes, I write my project on C#. I try call the web method from behavior code, through DataAdapter object. But method DataAdapeter.Query hasn't return values. How can I retrive out and return parameters after execution method?

Re: Retrive data after insert.

mika — Mon, 14 Nov 2005 19:59:14 GMT

quote:
When you create a new form, there is an option to create a form from a Web service. This will allow you to do both submit and retrieve.

Maybe, I inaccurately explain my situation. I have web method, like this:


[WebMethod]
public long CreateEntity(XmlNode bizEntity)
{
  long id = // generation id by bizEntity content;
  return id;
}

In infopath form I fill parameters, and send data to data base through this web method (CreateEntity). After inserting data, form must display newly created Id.

Standard way (creating data adapter in infopath designer) I can only send data. Return parameters from web method is nowhere displayed. Is exist a way to display this data?

Re: Retrive data after insert.

franck — Mon, 14 Nov 2005 18:25:14 GMT

Mika,

If you are confortable with managed code, you can even call a WS from your own code, bypassing the built-in mechanism. But, for now, I would go with what Patrick suggested.

Regards,

Franck Dauché

Re: Retrive data after insert.

Patrick Halstead — Mon, 14 Nov 2005 18:20:27 GMT

Hi Mika,
When you create a new form, there is an option to create a form from a Web service. This will allow you to do both submit and retrieve.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Retrive data after insert.

mika — Mon, 14 Nov 2005 18:13:16 GMT

Hello,

Indeed, I've already been using web service. But data source adapters has only send or retrive data, but not together.

Re: Retrive data after insert.

franck — Mon, 14 Nov 2005 17:16:12 GMT

Hi Mika,

How are you inserting your data? Maybe you could use a Web Service which would return IDs.

Regards,

Franck Dauché

Retrive data after insert.

mika — Mon, 14 Nov 2005 15:21:57 GMT

I have web method, that save data into DB's table when user click the button on form. All ID's of inserted rows generated by DB. How can I retrive this ID to the InfoPath-client?