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