Code

Re: Number and adding rows

Aruna Akella — Wed, 12 May 2010 20:38:38 GMT

This issue is resolved via e-mail.

Here is the piece of code to add rows dynamically to a repeating table via code (note: change the xpath)

           private void InsertBlankRow()
        {
            string myNamespace = NamespaceManager.LookupNamespace("my");
            using (XmlWriter writer = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Group53", this.NamespaceManager).AppendChild())
            {
                writer.WriteStartElement("Software_Serials", myNamespace);
                writer.WriteElementString("Software_Serial", myNamespace, string.Empty);
                writer.WriteElementString("Machines_Lookup", myNamespace, string.Empty);
                writer.WriteEndElement();
                writer.Close();
            }
        }

        public void Software_Purchased_Licenses_Changed(object sender, XmlEventArgs e)
        {
            // Write your code here to change the main data source.
            XPathNavigator root = MainDataSource.CreateNavigator();
            XPathNavigator test = root.SelectSingleNode("/my:myFields/my:Software_Purchased_Licenses", this.NamespaceManager);
            for (int i = 0; i < Int32.Parse(test.Value); i++)
            {
                InsertBlankRow();

            }
        }

Re: Number and adding rows

Aruna Akella — Wed, 12 May 2010 04:15:00 GMT

Attached the modified template - I used XmlWriter object to add a new row. Regarding the error you saw, can you please go through this post ?

Re: Number and adding rows

arcad — Tue, 11 May 2010 18:46:48 GMT

There it is. Thanks!

Re: Number and adding rows

Aruna Akella — Tue, 11 May 2010 17:43:20 GMT

Why don't you use the XmlWriter object that is returned by the AppendChild method of the XPathNavigator objcet to add a new row to a repeating tbl?

Can you post your template? - so that I can look at it later today....

Re: Number and adding rows

arcad — Tue, 11 May 2010 17:28:12 GMT

Thanks.

Here is my code:

XPathNavigator root = MainDataSource.CreateNavigator();

XPathNavigator test = root.SelectSingleNode("/my:myFields/my:Software/my:field1", this.NamespaceManager);

for (int i = 0; i < Int32.Parse(test.Value); i++)

{

XPathNavigator root2 = MainDataSource.CreateNavigator();

XPathNavigator group = root2.SelectSingleNode("/my:myFields/my:Software/my:group53/my:"RepeatingTable"[last()]", this.NamespaceManager);

XPathNavigator NewRow = group.Clone();

NewRow.InsertAfter(group);

}

The error is get that A calculation in the form has not been completed. The number of calculations used for a single action exceeded the maximum limit. The error is pointing to the "NewRow.InsertAfter(group)" line.

Any ideas? Thanks.

Re: Number and adding rows

Aruna Akella — Tue, 11 May 2010 17:13:07 GMT

Sorry about that. Can you try now?

Re: Number and adding rows

arcad — Tue, 11 May 2010 17:07:40 GMT

I cannot open the sample. It says this form cannot be opened because it requires the domain permission level and it currently has restricted permission. To fix this problem, open the form from the location it was published to.

Re: Number and adding rows

Aruna Akella — Mon, 10 May 2010 23:43:22 GMT

Yes. It's doable.

Add this code to your text box changed event:

XPathNavigator root = MainDataSource.CreateNavigator();

XPathNavigator test = root.SelectSingleNode("/my:myFields/my:field4", this.NamespaceManager); // here field4 is the field where user enters a number to add rows dynamically.

for (int i = 0; i < Int32.Parse(test.Value); i++)

{

InsertBlankRow(); // Write your logic to create a blank row(s) or row(s) with data

}

Attached a template file where I wrote a small sample to test it. Let me know if you have any questions.

Number and adding rows

arcad — Mon, 10 May 2010 19:20:25 GMT

Hello all,

I would like to know if it was possible to let the user type a number in a text box which would add that number of rows to an already existing repeating table. Lets say you type 25 and this action adds 25 rows to your repeating table in one shot.

Thanks in advance for your help!