General

Re: Querying a Web Service

Coita Thierry — Thu, 11 Aug 2005 06:14:31 GMT

Hi,

Like I say in my last post the easy way to verify the path in your secondary datasource is first see in design mode data source menu if your query fields exist

if not make an update of your secondary datasource for do this go on tools, dataconnection and clik your datasource (getPatient)and click modify do one more time this wizard and your data source is uptdated now see if your query fields are here!

and after to that step by step and after delete this control:

Put an expression box in design mode.
click Fx and after insert field or group
choose the field of your desire (in your case the query fields "SearchColumn")
after click the checkbox "edit XPath(advanced)" and infopath show you the good path compare with the path that you have in your code!

++

Thierry

Every moment hesitated is a moment gone for life!!! Think about it

Re: Querying a Web Service

Agni Jonnalagadda — Thu, 11 Aug 2005 03:38:29 GMT

Hi Speddi,
When you created the webservice connection, did you get the parameters to fill out?
If you got parameters to fill, then you should be able to see the prameters in the datasourse section in the InfoPath designer taskpane.

If the parameters are avalilable in the datasource, now open the dataconnections .xml file and check out if the parameters are available.

please check out all of the above things.

Agni
InfoPath Dev India

Re: Querying a Web Service

speddi — Wed, 10 Aug 2005 16:54:01 GMT

does not work.

I was debugging this and found out that there are no child nodes under dfs:queryfields

i debugges the following piece of code
domXML.selectSingleNode("dfs:myFields/dfs:queryFields")

Am i missing anything. Any help on this will be greatly appreciated

Thanks in advance.

--Sumanth.

speddi

Re: Querying a Web Service

Coita Thierry — Wed, 10 Aug 2005 09:07:35 GMT

Hi speddi,

Are you that RidNode1 is not empty? if you put this value in a string like this:

string toto= RidNode.text;

Have somethings inner? Put break point in the debugger for see

If it's the case! Are you sure that QueryInput has the good path in your secondary datasource? You can verify! Put an expression box in design mode click Fx and after insert field or group choose the field of your desire and after click edit XPath(advanced) and infopath show you the good path compare with the path that you have in your code!

++

Thierry

Every moment hesitated is a moment gone for life!!! Think about it

Re: Querying a Web Service

speddi — Tue, 09 Aug 2005 15:31:40 GMT

Hi Agni,

IXMLDOMDocument3 domXML = (IXMLDOMDocument3) thisXDocument.DataObjects["getPatient"].DOM;
domXML.setProperty("SelectionNamespaces", "xmlns:dfs=\"http://schemas.microsoft.com/office/infopath/2003/dataFormSolution\" xmlns:s0=\"http://tempuri.org/\"");
IXMLDOMNode QueryInput = objDO.DOM.selectSingleNode("dfs:myFields/dfs:queryFields/s0:getPatient/s0:SearchColumn");
IXMLDOMNode RidNode = thisXDocument.DOM.selectSingleNode("/my:myFields/my:SearchGroup/my:ddlSearch");
QueryInput.text = RidNode.text;

I tried what you have suggested and still get a System.NullReferenceException at the last line of the code given above. For some reason when I view domXML in the debuggeer window then I see that the node value is System.DBNull.Value and nodetypedvalue is System.DBNull.value am I missing something.

Thanks in advance

speddi

Re: Querying a Web Service

Agni Jonnalagadda — Tue, 09 Aug 2005 04:30:19 GMT

Hi Speddi,
On which line you are getting error here.
Try this out and let me know, on which line you are getting the error.

IXMLDOMDocument3 domXML = (IXMLDOMDocument3) thisXDocument.DataObjects["getPatient"];
domXML.setProperty("SelectionNamespaces", "xmlns:dfs=\"http://schemas.microsoft.com/office/infopath/2003/dataFormSolution\" xmlns:s0=\"http://tempuri.org/\"");

Agni
InfoPath Dev India

Querying a Web Service

speddi — Mon, 08 Aug 2005 21:32:41 GMT

Hi! I am trying to query a web service through managed code but somehow get this message that. The web service takes to input parameters namely serachcolumn and searchtext.

System.NullReferenceException
Object reference not set to an instance of an object.
at HLA.HLA.CTRL3_22_OnClick(DocActionEvent e) in c:\hla\formcode.cs:line 60
at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

Here is the code that I am following:

DataObject objDO = null;
objDO = thisXDocument.DataObjects["getPatient"];

IXMLDOMDocument3 domXML = (IXMLDOMDocument3) objDO.DOM;
domXML.setProperty("SelectionNamespaces", "xmlns:dfs=\"http://schemas.microsoft.com/office/infopath/2003/dataFormSolution\" xmlns:s0=\"http://tempuri.org/\"");
IXMLDOMNode QueryInput = objDO.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/s0:getPatient/s0:SearchColumn" );
IXMLDOMNode RidNode = thisXDocument.DOM.selectSingleNode("/my:myFields/my:SearchGroup/my:ddlSearch");
QueryInput.text = RidNode.text;
objDO.Query();

IXMLDOMNode QueryInput1 = objDO.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/s0:getPatient/s0:SearchText" );
IXMLDOMNode RidNode1 = thisXDocument.DOM.selectSingleNode("/my:myFields/my:SearchGroup/my:txtSearch");

QueryInput1.text = RidNode1.text;
objDO.Query();

I tried to follow the article listed in infopath dev using IXMLDOMDocument3 and changing the property it somehow does not work any suggestions!!!

Thanks in advacne

speddi