Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Populate Repeating Section with Web Service Data

Avatar of Beircheart
Beircheart asked on
XML.NET ProgrammingWCFInfoPathWeb Services
5 Comments1 Solution812 ViewsLast Modified:
Hi all,

I have an Infopath form that is used to gather information on New University Programmes and submit it to a database. This is working fine.
The form is also required to update existing programmes. So once the user selects a programme, I query a web service and this returns the required info in XML format.

I now need to populate a repeating section in the Programme form from the XML. Here is an example of the XML data that I am trying to use:
...
<ContributingDepts>
  <PRG_CODE>BAECSOUFA</PRG_CODE>
  <DEPT>Sociology</DEPT>
  </ContributingDepts>
- <ContributingDepts>
  <PRG_CODE>BAECSOUFA</PRG_CODE>
  <DEPT>Economics</DEPT>
  </ContributingDepts>
- <ContributingDepts>
  <PRG_CODE>BAECSOUFA</PRG_CODE>
  <DEPT>Mathematics and Statistics</DEPT>
  </ContributingDepts>
- <ContributingDepts>
  <PRG_CODE>BAECSOUFA</PRG_CODE>
  <DEPT>Psychology</DEPT>
  </ContributingDepts>
- <ContributingDepts>
  <PRG_CODE>BAECSOUFA</PRG_CODE>
  <DEPT>Management and Marketing</DEPT>
  </ContributingDepts>
...

How do I populate a repeating section with all the <DEPT>s for example? I can populate it sucessully if I "Change Binding" to the secondary data source (Web service) but this is not really an option as there is a complex workflow that is out of my hands already attached and changing bindings would destroy it.

If I try to populate field within the Repeating Section directly, it only shows the last one (i.e. Keeps overwriting rather than inserting new rows)

Any ideas?

Thanks a million,

Ben
ASKER CERTIFIED SOLUTION
Avatar of Beircheart
Beircheart

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers