Code

Re: add values to repeating table of a WS with JScript, infopath 2003

Ulk31 — Wed, 17 Dec 2008 13:38:18 GMT

Yeah, it works! Thank you very much for your help! The information to look in the template.xml helps a lot!

for others... this is my running code now:

>>
XDocument.View.ExecuteAction("xCollection::insert", "tbl_UserRow_11");
var userRowNode = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/tns:getInstanceResponse/tns:getInstanceResult/workitem/tbl_User/tbl_UserRow");
userRowNode.selectSingleNode("tbl_UserType").text = "Value of user type";
userRowNode.selectSingleNode("tbl_UserComment").text = "Value of user comment";
<<

My next step is to figure out how to select the other rows out of the tbl_User and not only the first . But I'll try to find this information in this forum.

Thank's a lot again!
Regards, Ulk

Re: add values to repeating table of a WS with JScript, infopath 2003

Shiva — Wed, 17 Dec 2008 12:58:06 GMT

Hello,

You will get these namespace in your template.xml and myschema.xsd files. In these files you have structured and with prefix of the node names. Those namespace prefixes might be change in code also.

If you are using InfoPath 2007,

Open form in Design mode.

Go to View -> Data Source.

Select your field and right click on that field.

Select ‘Copy XPath' option to select the path of the field.

Paste into notepad or in your formcode.cs file.

Go through the below links,

http://lists.xml.org/archives/xml-dev/200507/msg00199.html

http://msdn.microsoft.com/en-us/library/bb531390.aspx

Re: add values to repeating table of a WS with JScript, infopath 2003

Ulk31 — Wed, 17 Dec 2008 09:42:17 GMT

Hi,

ok, I went through the links. My code looks like this now:

>>
XDocument.DOM.setProperty("SelectionNamespaces", 'xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields" xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2006-03-08T23:17:48" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xmlns:tns="http://tempuri.org/"');

var userRowNode = XDocument.DOM.selectSingleNode("/my:myFields/dfs:dataFields/tns:getInstanceResponse/tns:getInstanceResult/d:workitem/d:tbl_User/d:tbl_UserRow");
userRowNode.selectSingleNode("tbl_UserType").text = "Value of user type";
<<

The issue "not declared namespace-prefix: 'd'" seems to be solved but running the next line throws "'null' or not an object". Therefore I think something must be wrong in the xpath - right?

Do you know where I can get information about the structure of a xpath? I don't know in which case I have to use my:, dfs:, tns: or d:.

Thank you very much for your help!
Regards Ulk

Re: add values to repeating table of a WS with JScript, infopath 2003

Shiva — Tue, 16 Dec 2008 17:56:03 GMT

Hello,

Go through the below link once,

http://www.infopathdev.com/forums/p/6196/22882.aspx#22882

http://www.infopathdev.com/forums/p/1319/6402.aspx#6402

Re: add values to repeating table of a WS with JScript, infopath 2003

Ulk31 — Tue, 16 Dec 2008 17:14:29 GMT

Hi Shiva,

thank you very much for your quick response. I tried it, but I get the error:

"not declared namespace-prefix: 'd'"

something must be wrong at the end of the xpath
...tns:getInstanceResult/d:workitem/d:tbl_User/d:tbl_UserRow"

Do you have any idea?

Regards Ulk

Re: add values to repeating table of a WS with JScript, infopath 2003

Shiva — Tue, 16 Dec 2008 16:57:52 GMT

Hello Welcome to the Forums,

Here is the code to add the new node to repeating node,

Var userRowNode = XDocument.DOM.selectSingleNode("/my:myFields/dfs:dataFields/tns:getInstanceResponse/tns:getInstanceResult/d:workitem/d:tbl_User/d:tbl_UserRow");

userRowNode.selectSingleNode("tbl_UserType").text = "Value of user type";

userRowNode.selectSingleNode("tbl_UserComment").text = "Value of user comment";

userRowNode.selectSingleNode("tbl_UserName").text = "Value of user name";

Note: You have to check the prefix of above XPath should be correct and check once XPath also.

add values to repeating table of a WS with JScript, infopath 2003

Ulk31 — Tue, 16 Dec 2008 16:39:00 GMT

Hi,

I'm albe to insert an new line with

XDocument.View.ExecuteAction("xCollection::insert", "tbl_UserRow_11");

but how can I add values to the fields of the new line?

My primary datasource (implemented as a webservice) looks like this:

- myFields
- dataFields
    - tns:getInstanceResponse
      - getInstanceResult
        - :workitem
            CurrentUserId
            CurrentUserName
          - tbl_User
            - tbl_UserRow
                tbl_UserType
                tbl_UserComment
                tbl_UserName

I seached a lot in this forum, but nothing help.

can anybody help?

Regards Ulk