InfoPath Dev

My InfoPath form contains Dropdownlist which contain list of years (200, 2001 and so….). I want that the values of it will arrive from data base source. I know that I can create Data connection in my form to the specific table in my SQL server. But… I don#%92t want to it by that way. I want to load the values to the Dropdownlist on the OnLoad event of the form (of course I'm using a web service witch have a method that return to me array (type string) with the values. My question is, after I get this array, what is the code for loading it to the Dropdownlist? Is it possible to do it on the OnLoad event?

One thing that you can do is map the DropDownList to a secondary Dom with similar structure and then in the OnLoad function get the data and either replace or insert it into the secondary DOM that is mapped to the dropdownlist.

The XML structure definitely needs to be same is this case otherwise the code will fail.

Hope this helps!

Shanthi
InfoPathDev India

How to do it???