InfoPath Dev

Hello there, I'm populating a List through code. I get the entries for the dropdown from a sharepoint list which has a lookup. The list holds informations about articles and has a lookup the specific colors for each article. Through the lookup I get a String for the colors which looks like this: "2;#red;#12;#blue". number and name are one line in the list i.e.

articlenumber: 2 name: red

articlenumber 12 name: blue

I hope you can imagine.

I create entries for each color-value pair in my main data source.  On the left side you see an image of my main data source. The color-value pairs are located in:

myFields/Bestellungen/Bestellung/ddArtikel/artikel/ddFarben/ddFarbe

The nodenames are: ddFarbeNr <- for the number, ddFarbeText <- for the name of the color

I create xml strings for every color and add them to ddFarben, right before the string (i.e.: 2;#red;#12;#blue) is splitted and "#" are removed. The split is saved into aFarben.

"<my:ddFarbeText>"+ aFarben[i] +"</my:ddFarbeText></my:ddFarbe>";

Hello,

Where you are getting empty entries in your dropdown list? If it is in starting then you have to change the code as below before adding the nodes.

Delete all child nodes for below node,

XmlNode ddFarbenNode = xnFarben.SelectSingleNode("../my:ddFarben", NamespaceManager);

ddFarbenNode. RemoveAll();

If the blank entries in the middle then you have to check code in your for loop. You might be adding some empty nodes to ddFarbenNode.

The function you postet does not work. SelectSingleNode has a return value an XPathNavigator object. Here are some images to show what I mean. One entry is correct and the other ones are not. I don't know why. They all use the same functions.

 Before adding the values I always delete all the nodes inside the ddFarben node. Here is my code:

try

MessageBox.Show(xnFarben.InnerXml);

char[] split = {';'};

//delete all nodes on the list

"<my:ddFarbeText>"+ aFarben[i] +"</my:ddFarbeText></my:ddFarbe>";

I don't know why it is different for the articles. Maybe it has something to do with the Sharepoint lookup. I don't know. When I retrieve the xml currently used there is everything allright, but anyhow there are these empty lines.

Hello,

You have to debug for below line,

xnFarben.SelectSingleNode("../my:ddFarben", NamespaceManager).AppendChild(sDDFarben);

In this ‘sDDFarben' node is empty for some times. For every node adding in your for loop, you have to check the ‘sDDFarben' node contains value or not.

Hope this helps you.

Hello Shiva, thank you for your advice. I have testet it and the String always contains the correct values. Not more, not less. Any other ideas ?

I found the error. It was in another function. I was deleting the Nodes before and created new ones, maybe there were too much. Anyway it works correct now. Thank you for trying to help me Shiva.

Thanks for letting us know. Glad to be of help :)