Fill a repeating table from a view

ghblackwell — Fri, 20 Aug 2010 12:38:03 GMT

I have a sql view assigned to a secondary data source in infopath. I'm trying to get the values from a filtered form of that view into a repeating table using VB.NET. I can clone the rows and assign values. My question is probably much simpler... How do I capture the view into a datatable to read from (or some other mechanism that I can loop through).

XPath to my filtered view looks like this - not that you need it.

"/dfs:myFields/dfs:dataFields/d:vwApplicationsImpactedByProjects/@application_name[../@project_number = xdXDocument:get-DOM()/my:myFields/my:bgProjectNumber and ../@package_number = xdXDocument:get-DOM()/my:myFields/my:bgPkgNumber]"

Thanks,

Greg

Code

Fill a repeating table from a view