Code

Re: Current Row in repeating table

hortonhouse — Fri, 24 Apr 2009 18:19:53 GMT

I have a mechansim where I select only the current item with a check box and unselect the previous, I then use a link button to allow selection of the correct row. The elements needed are firstly for InfoPath form Memebr variables (all in C#):

        /// <summary>
        /// Is a table postback. Changiong a check box value causes immediate postback which must be filtered out.
        /// </summary>
        private bool TablePostBack
        {
            get
            {
                return Convert.ToBoolean(FormState["TablePostBack"]);
            }
            set
            {
                FormState["TablePostBack"] = value;
            }
        }

        /// <summary>
        /// Prev table index.
        /// </summary>
        private int PrevTableIndex
        {
            get
            {
                return Convert.ToInt32(FormState["PrevTableIndex"]);
            }
            set
            {
                FormState["PrevTableIndex"] = value;
            }
        }

I then have a table which is bound in C# code behind in a method to data values as follows... Be sure that you specify the fields in the xmlWriter in the order in which they are in your data source and also that everything is in its own group otherwise you will get the shema validation errors problem...

                         // Iterative fields... Contact attachments... *************************************************************************************************************
                        XPathNavigator xmlItemAttachments = MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpAttachments", NamespaceManager);
                        // Remove first element since this is a given.
                        xmlItemAttachments.SelectSingleNode("/my:ReferralContact/my:grpAttachments/my:Attachments[1]", NamespaceManager).DeleteSelf();
                        foreach (ContactWrap.FormServiceProxy.AHLAttachment objAttachment in objData.ContactAttachments)
                        {
                            using (XmlWriter xmlWriter = xmlItemAttachments.AppendChild())
                            {
                                xmlWriter.WriteStartElement("Attachments", xmlItemAttachments.NamespaceURI);
                                xmlWriter.WriteElementString("AttachmentType", xmlItemAttachments.NamespaceURI, Convert.ToString(objAttachment.TypeResolved));
                                xmlWriter.WriteElementString("AttachmentName", xmlItemAttachments.NamespaceURI, objAttachment.Name);
                                xmlWriter.WriteElementString("AttachmentDescription", xmlItemAttachments.NamespaceURI, objAttachment.Description);
                                xmlWriter.WriteElementString("AttachmentVersion", xmlItemAttachments.NamespaceURI, Convert.ToString(objAttachment.Version));
                                xmlWriter.WriteElementString("AttachmentDate", xmlItemAttachments.NamespaceURI, XmlConvert.ToString(objAttachment.Date, "yyyy/MM/dd HH:mm:ss"));
                                xmlWriter.WriteElementString("chkSel", xmlItemAttachments.NamespaceURI, (objAttachment.Selected == true ? "1" : "0"));
                                xmlWriter.WriteEndElement();
                                xmlWriter.Close();
                            }
                        }
                        // *******************************************************************************************************************************************************

Now handle the event for the table repeating checkbox click and update the URL and URLText values for which a Link button is bound to in data...

/// <summary>
        /// Check box click event.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public void chkSel_Changed(object sender, XmlEventArgs e)
        {
            // Only with valid entry change, not just load event.
            if (e.OldValue != string.Empty)
            {
                int intSelectedIndex = -1;
                XPathNodeIterator xmlNodesCheck = MainDataSource.CreateNavigator().Select("/my:ReferralContact/my:grpAttachments/my:Attachments", NamespaceManager);
                int intCount = -1;
                foreach (XPathNavigator xmlNodeNav in xmlNodesCheck)
                {
                    ++intCount;
                    if (xmlNodeNav.SelectSingleNode("my:chkSel", NamespaceManager).Value == "1")
                    {
                        intSelectedIndex = intCount;
                        // this.LastTableIndex = intCount;
                        if (this.PrevTableIndex != intCount)
                        {
                            // Reset old value.
                            int intInnnerCount = -1;
                            foreach (XPathNavigator xmlNodeNavInner in xmlNodesCheck)
                            {
                                if (++intInnnerCount == this.PrevTableIndex)
                                {
                                    // Evaluluate all...
                                    xmlNodeNavInner.SelectSingleNode("my:chkSel", NamespaceManager).SetValue("0");
                                    // Stop immediate reprocess for old item undo.
                                    this.TablePostBack = true;
                                    break;
                                }
                            }
                            this.PrevTableIndex = intCount;
                            break;
                        }
                    }
                }
                // Reconcile to data. Set HTML link values ready for use...
                if (this.ListOfAttachmentsCached != null && this.ListOfAttachmentsCached.Length > 0 && intSelectedIndex >= 0)
                {
                    // Get the link from the contact attacment library link data element which has already been set.
                    if (MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpControl/my:ContactAttachmentLibraryLink", NamespaceManager).Value == string.Empty)
                    {
                        // Point to lib.
                        MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpControl/my:AttachmentSelectedItemLinkURLText", NamespaceManager).SetValue("Error: Could not obtain attachmement library URL...");
                        MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpControl/my:AttachmentSelectedItemLinkURL", NamespaceManager).SetValue(MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpControl/my:ContactAttachmentLibraryLink", NamespaceManager).Value);
                    }
                    else if (this.ListOfAttachmentsCached[intSelectedIndex].Name == string.Empty)
                    {
                        // Point to empty. Can't do anything.
                        MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpControl/my:AttachmentSelectedItemLinkURLText", NamespaceManager).SetValue("Error: Could not obtain attachment item details....");
                        MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpControl/my:AttachmentSelectedItemLinkURL", NamespaceManager).SetValue(string.Empty);
                    }
                    else
                    {
                        string strLinkURL = MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpControl/my:ContactAttachmentLibraryLink", NamespaceManager) + "/" + this.ListOfAttachmentsCached[intSelectedIndex].Name;
                        MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpControl/my:AttachmentSelectedItemLinkURLText", NamespaceManager).SetValue("Open");
                        MainDataSource.CreateNavigator().SelectSingleNode("/my:ReferralContact/my:grpControl/my:AttachmentSelectedItemLinkURL", NamespaceManager).SetValue(strLinkURL);
                    }
                }
            }
        }

Re: Current Row in repeating table

Jimmy — Mon, 23 Mar 2009 05:37:21 GMT

Those instructions make sense to me. Are you sure you modified the manifest the way they described? Perhaps you could attach your manifest.xsf file to this thread so we can have a look?

Re: Current Row in repeating table

Fawzy — Mon, 23 Mar 2009 05:08:11 GMT

Hi Santhoshp,

I tried your approach below to select only one radio button in a repeating table but it didn't work, now I'm not able to select any radio button!

am I missing something?

Thanks

Hi,
Follow these steps to select only one radio button in repeating table.
Add a rule on the radio button field.
Set the condition: the expression “. = 1”
Add an action:
   1. For action drop down select set fields value.
   2. Select radio button field by using data source button.
   3. In value text box set 0.

Save the xsn as source files and open the manifest.xsf in notepad.
1. Search for the Rule name(e.g Rule 2) that you have given. You will find this node
   <xsf:rule caption="Rule 2" condition=". = 1" isEnabled="yes">
2. Below this node you will find targetField attribute.
3. Use the following XPath in that attribute value.
   targetField="../preceding-sibling::my:group4/my:field2|../following-sibling::my:group4/my:field2"
here group4 is repeating group and field2 is radio button.
4. Save the manifest.xsf and preview it.

Re: Current Row in repeating table

savita — Tue, 13 Jan 2009 14:49:11 GMT

Hi Jimmy, Thanks for a quick reply. You saved me. Again!!! I made the changes you suggested and it's working. Thanks.

Re: Current Row in repeating table

Jimmy — Tue, 13 Jan 2009 14:28:30 GMT

Your first line is counting the number of nodes named "Row" preceding eventObj.source, but from the third line, it looks like the repeating node is called "d:q_inflow_entry", not "Row". That's probably why count is always 1.

In the third line, you have the literal characters c-o-u-n-t in your XPath string instead of concatenating the value of the count variable into the string.

But you should not need that roundabout approach to get the value of the node you want. If d:q_inflow_entry is in fact the repeating node, then

Req_Id = eventObj.Source.selectSingleNode("@request_id").value

Should do the trick.

Re: Current Row in repeating table

savita — Tue, 13 Jan 2009 14:08:18 GMT

Hi. I have a repeating table with a button in each row. I'd like to get the value of a field in the same row in the OnClick event.

I went through this post. I am using IP2003 with VBScript. I tried the following:
count = eventObj.Source.selectNodes("preceding-sibling::Row").length + 1
msgbox(count)
Req_Id = eventObj.Source.selectSingleNode("/dfs:myFields/dfs:dataFields/d:q_inflow_entry[count]/@request_id").value

But count returns 1 everytime no matter which row I select. And the last line throws an exception 'Object required'. Please help.

Re: Current Row in repeating table

swathip — Fri, 21 Nov 2008 09:03:32 GMT

Hi,

I think your radio button is binded to the field out of repeating section. Make sure that the radio button field is in the repeating section in the data source. And use the following code in the field on after change.

[InfoPathEventHandler(MatchPath = "/my:myFields/my:group3/my:group4/my:field7", EventType = InfoPathEventType.OnAfterChange)]

public void group4_OnAfterChange(DataDOMEvent e)

{

if (e.IsUndoRedo || e.Parent.nodeName != "my:field7" || e.Site.text != "1")

{

return;

}

if (e.Source.text == "1")

{

IXMLDOMNode parentNode = e.Source.selectSingleNode("..");

int currentRowPosition = parentNode.selectNodes("../precedingsibling::my:group4").length + 1;

IXMLDOMNodeList field7Nodes = thisXDocument.DOM.selectNodes(string.Format("/my:myFields/my:group3/my:group4[position() != {0}]/my:field7[. = '1']", currentRowPosition));

foreach (IXMLDOMNode field7Node in field7Nodes)

{

field7Node.text = "0";

}

Here my:group4 is the repeating field and my:field7 is the radio button field.

Re: Current Row in repeating table

santhoshp — Fri, 21 Nov 2008 06:08:55 GMT

Hi,

Follow these steps to select only one radio button in repeating table.

Add a rule on the radio button field.
Set the condition: the expression “. = 1”
Add an action:
   1. For action drop down select set fields value.
   2. Select radio button field by using data source button.
   3. In value text box set 0.

Save the xsn as source files and open the manifest.xsf in notepad.
1. Search for the Rule name(e.g Rule 2) that you have given. You will find this node
<xsf:rule caption="Rule 2" condition=". = 1" isEnabled="yes">
2. Below this node you will find targetField attribute.
3. Use the following XPath in that attribute value.
targetField="../preceding-sibling::my:group4/my:field2|../following-sibling::my:group4/my:field2"

here group4 is repeating group and field2 is radio button.
4. Save the manifest.xsf and preview it.

Re: Current Row in repeating table

rishibajaj — Fri, 21 Nov 2008 02:21:58 GMT

I was able to achieve the goal of selecting prospectid for checked boxes. Thank you so much for your great help. Here is my final code that works

XPathNavigator source = MainDataSource.CreateNavigator();

XPathNodeIterator row = source.Select("/dfs:myFields/dfs:dataFields/tns:HelloWorldResponse/tns:HelloWorldResult/NewDataSet/Table[mycol='1']", NamespaceManager);

//XPathNodeIterator row1 = source.Select("/dfs:myFields/dfs:dataFields/tns:HelloWorldResponse/tns:HelloWorldResult/NewDataSet/Table/ProspectFName", NamespaceManager);

foreach (XPathNavigator selectnode in row)

{

string value = selectnode.SelectSingleNode("ProspectId").Value;

}

Re: Current Row in repeating table

rishibajaj — Fri, 21 Nov 2008 00:59:05 GMT

I am so sorry if I have confused you. I have a field prospectid in repeating table which comes from the database along with other fields. I wanted to put the checkbox in repeating table so that uses can select the prospects from the repeating table to delete them. I was able to put the check box by putting boolean dummy field in select statement and binding that checkbox with that dummy boolean field.

I still have to do the same thing but the code that i showed in last post i used firstname but it was for testing.

Goal is still the same to select the prospects from the repeating table to delete them. So I have to figure out which checkboxes are selected so that i can pass the prospectid of those selected items to stored procedure for deleting them. Prospectid is one of the fields in repeating table.

I hope I am not confusing you any more.

Here is the list of my objects Please let me know how can I accomplish this goal. Thanks

rootDefaultData = DataSources["FProspect"].CreateNavigator();
XPathNavigator dataFields = rootDefaultData.SelectSingleNode("/dfs:myFields/dfs:dataFields", NamespaceManager);
XPathNavigator prosResp = dataFields.SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:FProspectResponse", NamespaceManager);
XPathNavigator prosResult = dataFields.SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:FProspectResponse/tns:FProspectResult", NamespaceManager);
XPathNodeIterator nodeDefaultData = dataFields.Select("/dfs:myFields/dfs:dataFields/tns:FProspectResponse/tns:FProspectResult/tns:FetchProspect/tns:FirstName", NamespaceManager);

Re: Current Row in repeating table

Hilary Stoupa — Thu, 20 Nov 2008 23:35:22 GMT

Well, the code you've highlighted in bold suggests that you would have a data node at:

/dfs:myFields/dfs:dataFields/tns:FProspectResponse/tns:FProspectResult/tns:FetchProspect/tns:FirstName/d:field

which seems reasonably unlikely.

Use XPathNavigator to select a single node, and XPathNodeIterator to select a list of nodes. Unless First Name is a list (which I doubt), you would want to use XPathNavigator. From your earlier code snippet, I thought you wanted to get a list of all the nodes that have been selected with your checkbox in your form. At this point, I'm afraid I'm not feeling like I understand what you are hoping to accomplish.

What do you need the code in your form to do, exactly?

Re: Current Row in repeating table

rishibajaj — Thu, 20 Nov 2008 23:16:33 GMT

Thank you, I got some idea after seeing your code and I was able to make some progress. I did this in my code

XPathNavigator rootDefaultData = DataSources["FProspect"].CreateNavigator();

XPathNodeIterator dataFields = rootDefaultData.Select("/dfs:myFields/dfs:dataFields/tns:FProspectResponse/tns:FProspectResult/tns:FetchProspect/tns:FirstName", NamespaceManager);

foreach (XPathNavigator selectedNode in dataFields)

{

string value = selectedNode.InnerXml;

}

but i am wondering that why your this code is not working when it should have worked. I implemented your code that is in bold below but it's not working.Can you please tell why? Value of variable value will not change.

foreach (XPathNavigator selectedNode in dataFields)
{
string value = selectedNode.SelectSingleNode("d:field").Value;
}

Re: Current Row in repeating table

Hilary Stoupa — Thu, 20 Nov 2008 22:25:48 GMT

Well, first off, I'd use my XPath in the second navigator to select only the nodes in the dataFields group that have a value of True (if that is what selecting the checkbox sets the field to) in the checkbox node. And I'd make it an XPathNodeIterator, so it has all of the nodes where the filter applies.

XPathNodeIterator dataFields = myfields.SelectSingleNode("/dfs:myFields/dfs:dataFields[d:checkboxfield = 'True']", NamespaceManager);

Naturally, you'll want to replace 'd:checkboxfield' with the relative XPath from dfs:dataFields to your check box field, and if you are setting the value to something other than true, To get the values, you can use something like:

foreach (XPathNavigator selectedNode in dataFields)
{
string value = selectedNode.SelectSingleNode("d:field").Value;
}

This is just pseudo-code, so I may have a syntax error or two hanging about.

Re: Current Row in repeating table

rishibajaj — Thu, 20 Nov 2008 19:41:21 GMT

Thanks for your response.

I exactly did that and now I have a checkbox in repeating table. I want to go through each and every row in repeating table and see in which rows the checkbox is selected. Once I know the selected check box rows i need to get prospect id of those rows.

In the lines below I made the navigator object of datasource and then navigator object of data fields. Now when i debug into code then I can see innerxml of dataFields has all the rows of repeating table.

My question to you is how should i parse the value of each node of every row in datafields object to get the values of element?

XPathNavigator myfields = DataSources["FProspect"].CreateNavigator();

XPathNavigator dataFields = myfields.SelectSingleNode("/dfs:myFields/dfs:dataFields", NamespaceManager);

Re: Current Row in repeating table

Hilary Stoupa — Thu, 20 Nov 2008 19:30:13 GMT

Well, I wonder. In your main data connection, if you walk through the wizard again, you could click the 'Edit SQL' button and add to your select clause to create a dummy boolean.... like select col1, col2, 'False' as Selected .... then you should have a column called 'Selected' in your data source set to false that you could use for your checkbox in your repeating table. I warn you -- I haven't actually tried this, but why don't you see if works?