Newbie Questions

Re: Add row to repeating table

GazM — Thu, 18 Dec 2008 13:06:50 GMT

Try looking at this forum discussion http://www.infopathdev.com/forums/t/9514.aspx

Gary

Re: Add row to repeating table

Jimothias — Thu, 18 Dec 2008 09:27:11 GMT

Frederik

Thanks for the post but I'm sorry I cant seem to find the NameNodeInManifest string anywhere in the manifest.xsf file. Sorry to be a pain I've only been using Infopath for about 3 months :0(. Also I think that is C# code and in the code editor I have to use VB for some reason?!? Maybe because I dont have VS installed maybe?

Any pointers would be brilliant :0)

Thanks again

James

Re: Add row to repeating table

Frederik Van Lierde — Wed, 17 Dec 2008 17:04:50 GMT

You need to access this Manifest file, the following line shows how to get e newRow node

XPathNavigator xnNode = this.Template.Manifest.SelectSingleNode("//xsf:xDocumentClass/xsf:views/xsf:view/xsf:editing/xsf:xmlToEdit[@name='NameNodeInManifest']/xsf:editWith/xsf:fragmentToInsert/xsf:chooseFragment/my:RepeatingNode", this.NamespaceManager);

So first you Save as source file, go to the manifest:xsf en try to find the NameNodeInManifest, This will be the nodename with a number

After the first part of the code, append the new structure, when you delete the complete range, InfoPath doesn't know the structure anymore

xnGroupNode.SelectSingleNode("/my:expenseReport/my:MyControls", this.NamespaceManager).AppendChild(xnNode.InnerXml);

//-- Get the newest appended node --
xnNewRow = xn.SelectSingleNode("/my:expenseReport/my:MyControls/my:MyControl[last()]", this.NamespaceManager);

// Add the data to the new row
xnNewRow.SelectSingleNode("my:Source", this.NamespaceManager).SetValue("some data")

Hope this will help you

Add row to repeating table

Jimothias — Wed, 17 Dec 2008 16:53:16 GMT

Afternoon everyone

I hope someone can help me, what I've got is a repeating table with 2 buttons at the top of the screen. the first button shows the table (by default the repeating table is hidden) the second button hides the table and removes all the rows using this vb code:

Public Sub ButtonMiscExpensesNo_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)

' Retrieve a reference to the Main DOM
Dim root As XPathNavigator = MainDataSource.CreateNavigator()

' Count the amount of group2 nodes
Dim iter As XPathNodeIterator = root.Select( _
"/my:myFields/my:MiscExpensesSection/my:MiscExpenseTable/my:MiscEntertainmentExpenses", _
NamespaceManager)
Dim group2NodesCount As Integer = iter.Count

' Retrieve the first group2 node
Dim firstGroup2NodeNav As XPathNavigator = _
root.SelectSingleNode("/my:myFields/my:MiscExpensesSection/my:MiscExpenseTable/my:MiscEntertainmentExpenses[1]", _
NamespaceManager)
' Retrieve the last group2 node

Dim lastGroup2NodeNav As XPathNavigator = _
root.SelectSingleNode("/my:myFields/my:MiscExpensesSection/my:MiscExpenseTable/my:MiscEntertainmentExpenses[" & _
group2NodesCount.ToString() & "]", _
NamespaceManager)

' Delete the range of nodes from the first to the last group2 nodes
firstGroup2NodeNav.DeleteRange(lastGroup2NodeNav)
End Sub

This hides the table once the rows have been deleted. The reason they get deleted is so the fields are fresh incase the user changes his/her mind again and want to use the repeating table. Does anyone know what code I should add (in VB please) to add a row to the table using the button that shows the table? The code below doesn;t work and complains about incorrect data type and no matter what I try it just fails :0(

Dim myNamespace As String = NamespaceManager.LookupNamespace("my")
Using writer As XmlWriter = MainDataSource.CreateNavigator().SelectSingleNode( _
"/my:myFields/my:MiscExpensesSection/my:MiscExpenseTable", NamespaceManager).AppendChild()
writer.WriteStartElement("MiscEntertainmentExpenses", myNamespace)
writer.WriteElementString("MiscEntertainmentDate", myNamespace, "")
writer.WriteElementString("MiscEntertainmentExpense", myNamespace, "")
writer.WriteElementString("MiscEntertainmentNet", myNamespace, "0")
writer.WriteEndElement()
writer.Close()
End Using

Any hints or pointers will be appreciated.

Thanks in advanc

James