General

Re: Populating Dropdowns at Run-Time

Lewis68 — Tue, 24 Jan 2006 20:12:06 GMT

I got it to work.

Thanks for the info.

Re: Populating Dropdowns at Run-Time

Matt Faus — Tue, 24 Jan 2006 19:01:46 GMT

If your drop-down list is already populating from the SQL DB then all you need to do is retrieve the rows from the DB and the drop-down will automatically populate. To do this, add this code to your OnLoad event handler:

XDocument.Query();

--OR--

XDocument.DataObjects("Name of secondary data source").Query();

These two bits of code are the same thing as clicking the "Run Query" button generated on the form and can also be accomplished using rules of the Open/Save functionality in Form Options.

---------------
Matt Faus
InfoPath Dev Texas

Populating Dropdowns at Run-Time

Lewis68 — Tue, 24 Jan 2006 17:51:25 GMT

Hello,

I know this has been covered before, but I can't seem to find an example. I need to populate a Dropdown with results from a SQL DB query at run-time. Can I get an example on how to do this?

Thanks.