General

Re: delete a row in a repeating table

Skarn — Thu, 21 Apr 2011 22:32:22 GMT

This code must be in the click event of the button?

I've always found I can use the eventObj object of the event to easily delete the repeating row/section.
First, my remove button is usually inside the repeating section, or in an empty column at the end of the table, or next to the final control in the last column.

Then I call something like eventObj.Source.nodeParent.removeChild(eventObj.Source);

Re: delete a row in a repeating table

g21cincy — Thu, 14 Apr 2011 19:23:02 GMT

I've done this before using code behind a button in VB. I added a Remove field to the table I used for my repeating table.

tblTest will be my example table

ID is the primary key that increments by 1 for each row

'table1' will be my data source used for the table using tblTest

'table remove row' will be my data source used to make connection to tblTest

-----------------------------------------------------------------------------------

Dim Nav As XPathNavigator = Me.DataSources("table1").CreateNavigator()

Dim Conn As AdoQueryConnection = Me.DataConnections("table remove row")

Dim rows As XPathNodeIterator = Nav.Select("/dfs:myFields/dfs:dataFields/d:tblTest", NamespaceManager)

Dim iCounter As Integer = 1

While rows.MoveNext()

If GetValue("/dfs:myFields/dfs:dataFields/d:tblTest[" & iCounter & "]/@Remove", Nav) = "yes" Then

Conn.Command = "DELETE FROM tblTest " & _

"WHERE (ID = '" & GetValue("/dfs:myFields/dfs:dataFields/d:tblTest[" & iCounter & "]/@ID", Nav) & "')"

Conn.Execute()

End If

iCounter += 1

End While

Hope this helps you out!

Re: delete a row in a repeating table

TerryB — Wed, 06 Apr 2011 18:53:33 GMT

You need to specify the array item in the repeating element i.e. if Contact_Member_Names is repeating you'll need Contact_Member_Names[n] where n is the node position - you can check using position(). Also I'm guessing that d:Contact.... should read dfs:Contact.... Hope this helps.

delete a row in a repeating table

chris317 — Wed, 06 Apr 2011 17:16:30 GMT

Hello,

I'm attempting to delete a row from a repeating table when a button is clicked. So far I have been unsuccessful in getting the code below to work. I'm not recieving any type of error but when the button is pressed nothing happens. Can someone let me know how to correct this?

objXMLNode = XDocument.DOM.selectNodes("/dfs:myFields/dfs:dataFields/d:Contact_Member_Names/@Office");

objXMLNode.removeAll();