-
See the attached sample - I used an XML file for the days of the week data and a filtered default that leverages the count of preceding siblings. :)
Just in case you didn't know this - save the file locally, right click and select design to open in design mode.
-
XPathNodeIterator dataNodes = QVData.Select("/dfs:myFields/dfs:dataFields/d:AD_Mirror", this.NamespaceManager);Should get you an iterator - then you can loop through them - you may need to right click AD_Mirror in the fields taskpane in the designer and select copy XPath to make sure the XPath is right above...
Then you ...
-
You'll need to create an XPath navigator for the data source - just roughing this, so it may need some clean up - but XPathNavigator adData = this.DataSources["AD_Mirror"].CreateNavigator() should get you the root of the returned data - then you can use SelectSingleNode or Select to get node(s) back....
-
If you are using browser forms, you'd need to check the file out the user to prevent them from accidentally overwriting each other. I have a blog post on that which might help you get started - please note it is a few years old. http://www.infopathdev.com/blogs/hilary/archive/2010/11/10/check-that-form-out-or-in-automatically.aspx
-
Interesting. So you are getting the form data connection, and it appears setting the connection string, then commented out the connection.Execute() line (which would have run the query for the data connection you already accessed) and create an OleDbConnection instead? I confess, I don't understand why.... You should be able to uncomment ...
-
If you use Internet Explorer, the forum will leave your post formatting alone. Can you just use a SQL data connection in the form and modify the command for the data connection in your code? I'd guess if you did that instead of using an OleDBConnection, you wouldn't have to go full trust.
-
Sure - I'm not going to be around on Monday (US holiday) but I'll take a look early next week.
-
If the data is not going to change, may as well use an XML file for it - feel free to attach your template w/ your work around to a reply (under the options tab) and I'll take a look in the next day or so.
-
Hi - no, InfoPath doesn't do this, I'm afraid.
-
Hey, Marc -
Is this a list form you are customizing in InfoPath? I ask because your formulas look like calculated SharePoint column values, not InfoPath formulas.
If you need to manage multiple list items with your form (it sounds like you do?) you need to start from InfoPath designer, select SharePoint List form as the ...