Patrick Halstead:
Hi Luke,
The best practice here is to map your data to a SQL database and use SharePoint's out-of-box data view webpart to display the contents. No code required.
Hi Patrick,
Thanks for your response. However I am not needing to display the repeating tables' values, I need to iterate through each set of repeating values and then manipulate them in web part.
The scenario is: customer orders are recorded on an InfoPath order form where products are in a repeating table as there can be many products per customer order that comes in. Different views in the form make up the Order Acknowledgement / Delivery Note / Goods In Note and will soon make up an invoice. However I need to write a web part to allow a selected "delivered" order to have it's products, their quantities and unit prices passed into Sage (using Sage's SDK) to save the accounts department having to re-enter this information into their financial software (Sage).
I have attempted to make my way around the SQL created database for SharePoint in the past but it is so intertwined i have always stayed clear of going into it... Therefore I feel it would be too complicated to go looking for the InfoPath XML document in the SQL database to draw the data out. Is there a way, in code, that I can open the InfoPath XML form, retrieve the XML and then loop through the repeating table, like I would do a normal set of XML data?
Thank you for your help so far, if you can provide any further pointers / help this would be very much appreciated!!
Many Thanks,
Luke