Re: Adding checkbox into repeating table programmatically (C#)

Hilary Stoupa — Thu, 19 Nov 2015 19:49:08 GMT

Oh wow - didn't expect it to be that easy. :) Glad it is working for you!

Re: Adding checkbox into repeating table programmatically (C#)

arkainus — Thu, 19 Nov 2015 19:24:14 GMT

Nice, that was it. There was nothing in the checked/unchecked values on the control, and that was what was causing the issue. I'm not sure how it came to be that there was no value in there, but as soon as I filled those dropboxes in, the code now works. Thank you Hilary!

Re: Adding checkbox into repeating table programmatically (C#)

Hilary Stoupa — Thu, 19 Nov 2015 18:55:43 GMT

In your form, what is the data type for the field bound to the checkbox? If you right click the checkbox, what are the checked and unchecked values?

Re: Adding checkbox into repeating table programmatically (C#)

arkainus — Thu, 19 Nov 2015 18:46:12 GMT

Sorry - tried updating the post - the code stripped out some locations, and the innerxml I show also got stripped, and my edits weren't fixing it and I didn't want to keep editing the post unsuccessfully. I put the code in the attached txt file, as well as the innerxml example. Thank you again for any help you may have to offer.

Adding checkbox into repeating table programmatically (C#)

arkainus — Thu, 19 Nov 2015 18:18:29 GMT

Hey Everyone,

I have a form with a button that I want use to programmatically retrieve sql data, fill it into a sqldatareader object, which I use to populate a stringbuilder string, to finally append as a child to a repeating table element in infopath. The repeating table has five fields in the schema, four of which are text, and one of which is a boolean value. My code seems to work, but unfortunately, when I go to place a check in one of the checkboxes that populates due to this code, the box receives a red highlight telling me "Only 'true' or 'false' allowed".

My code looks like the following:

	    //reset all rows on the repeating table
            XPathNavigator mainDS = MainDataSource.CreateNavigator();
            StringBuilder sb = new StringBuilder();
            XPathNavigator firstRow = mainDS.SelectSingleNode("/my:myFields/my:updatePartyInfo/my:partyTable/my:group8/my:group9", NamespaceManager);
            XPathNavigator lastRow = mainDS.SelectSingleNode("/my:myFields/my:updatePartyInfo/my:partyTable/my:group8/my:group9[position() = last()]", NamespaceManager);
            if (firstRow != null && lastRow != null)
                firstRow.DeleteRange(lastRow); //Make try/catch to ignore exception if called on a table that has already been cleared (i.e. first run retrieved no records)

            using (SqlCommand command = connection.CreateCommand())
            {
                //command.CommandText = queryString;
                command.CommandText = sqlQuery;

                connection.Open();

                using (SqlDataReader reader = command.ExecuteReader())
                {
                    int count = 1;
                    string my = NamespaceManager.LookupNamespace("my");
                    string xpath = "/my:myFields/my:updatePartyInfo/my:partyTable/my:group8/my:group9";
                    XPathNavigator group = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager);
                    while (reader.Read())
                    {
                        string partyCode = reader["party_code"].ToString();
                        string rowId = count.ToString();
                        string contID = reader["event_code"].ToString();
                        string address = reader["full_addr"].ToString();
                        sb.Append("");
                        sb.Append("" + count.ToString() + "");
                        sb.Append("" + contID + "");
                        sb.Append("" + partyCode + "");
                        sb.Append("" + address + "");
                        sb.Append("true");
                        sb.Append("");
                        count++;
                    }
                }
                connection.Close();

                sb = sb.Replace("&", "ampersand;"); //fields with ampersands throw schema validation
                MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:updatePartyInfo/my:partyTable/my:group8", NamespaceManager).AppendChild(sb.ToString());

I'll also attach as a text file, as I always have trouble getting the formatting to look good on this forum. The selectThisParty field is the checkbox field. In the example above, I'm giving it a value of true. I've tried "TRUE", "false", "FALSE" and leaving the value blank, which all produce errors - the uppercase and blank examples making the field surrounded by the red invalid markers right upon population, whereas the lowercase looks good, until you try and actually populate a check into one of the boxes - then that individual box is surrounded with the red markers.

So my question is - is there something special I have to be doing here when inserting a checkbox versus a text field? I use the sb object compile all of the elements because I noted that large datasets were significantly faster this way - one appendchild() call, rather than multiple appendchildelements(). Does anyone have any ideas what I'm screwing up here? The frustrating thing is if I compare the InnerXML of the table when created by default, the selectThisParty is represented like so:

"false"

. My code produces the same thing, so it seems like it should work. I'd love to see if anyone has any pointers on what I'm doing wrong, or how I might fix. Thank you in advance for your time.