How to dynamic populdate data for dropdown list control?

[Forrest]

Hi,

I have a dropdown list in InfoPath form. This dropdown list gets data from
xml secondary data source.

The content of xml secondary data source is large (over 1000 nodes). What we
want to do is provide a textbox to let end user input some search criteria,
and then based on input search criteria to filter data in dropdown list.

Would you please help me out or give some guide? Many thanks!

Forrest

 

[Clay Fox]

Hi Forrest.
The Key is being able to query a secondary data source, which you cannot do
with a standard data connection.

The key is a webservice or code. I use web services to query a database
table dynamically in this kind of situation.

So it can be done just needs additonal components.

 

[Forrest]

Hi Clay,

Thank you so much for your reply.

Our InfoPath form is a standalone form which doesn't access Web Service or
Database.

I saw some code on internet to demo on populating dynamic dropdown on Form
Load event handler. But my form need to fiter data on dropdown list on
Command event handler.

InfoPath has build-in support to filter data on dropdown list. But we need
to achieve it by using code behind as InfoPath build-in filter data support
is not good enough for our case.

So is there nayway that could filter data on dropdownlist by using code
behind?

Many thanks,

Forrest

 

[Clay Fox]

I believe there are some code samples on http://www.infopathdev.com

You should be able to search there and find some examples.