//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);

            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("<my:group9 xmlns:my=\"" + my + "\">");
                        sb.Append("<my:relPartyRowID xmlns:my=\"" + my + "\">" + count.ToString() + "</my:relPartyRowID>");
                        sb.Append("<my:relPartyCntId xmlns:my=\"" + my + "\">" + contID + "</my:relPartyCntId>");
                        sb.Append("<my:relPartyName xmlns:my=\"" + my + "\">" + partyCode + "</my:relPartyName>");
                        sb.Append("<my:relPartyAddress xmlns:my=\"" + my + "\">" + address + "</my:relPartyAddress>");
                        sb.Append("<my:selectThisParty xmlns:my=\"" + my + "\">" + "</my:selectThisParty>");
                        sb.Append("</my:group9>");
                        count++;
                    }
                }
                connection.Close();

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






InnerXML example: <my:selectThisParty xmlns:my=\"http://schemas.microsoft.com/office/infopath/2003/myXSD/2015-11-17T15:34:17\">false</my:selectThisParty>