InfoPath Dev

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.

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

I got it to work.

Thanks for the info.