General

Re: Inserting into Repeating Table Programmatically

vasanthaprabu — Fri, 10 Mar 2006 10:04:54 GMT

No Problem I got it.

I have to remove one extra group name thats all.

Regards,
Vasanth.

Re: Inserting into Repeating Table Programmatically

vasanthaprabu — Fri, 10 Mar 2006 09:59:32 GMT

Hello Agni,

Here is my Code:

[InfoPathEventHandler(MatchPath="btnShow", EventType=InfoPathEventType.OnClick)]
public void btnShow_OnClick(DocActionEvent e)
{
try
{
string RepeatingXML = "<my:XMLTable xmlns:my='http://schemas.microsoft.com/office/infopath/2003/myXSD/2006-03-10T08-06-14'><my:Username>Vasanth</my:Username><my:Age>23</my:Age><my:City>Bangalore</my:City></my:XMLTable>";

IXMLDOMDocument oXML = thisXDocument.CreateDOM();
oXML.async = false;
oXML.loadXML(RepeatingXML);

IXMLDOMNode ParentTable = thisXDocument.DOM.selectSingleNode("my:myFields/my:XMLView/my:XMLTable");

ParentTable.appendChild(oXML.documentElement);
}
catch(Exception ex)
{
ErrorMsg.text = ex.Message;
}
}

But its not working porperly...

Error is:

Element 'http://schemas.microsoft.com/office/infopath/2003/myXSD/2006-03-10T08-06-14}XMLTable' is unexpected according to content model of parent element 'http://schemas.microsoft.com/office/infopath/2003/myXSD/2006-03-10T08-06-14}XMLTable'.

Can you please help me!

Regards,
vasanth.

Re: Inserting into Repeating Table Programmatically

potpourri — Sun, 17 Apr 2005 04:59:56 GMT

hihihi

yeah it works now.
super duper thanks for this...saved me a lot of trouble, really! :D

Re: Inserting into Repeating Table Programmatically

Agni Jonnalagadda — Fri, 15 Apr 2005 08:09:20 GMT

It looks like your XML has a prefix of "my" so you need to add "my" as a prefix to your XML string also. And one more thing you need to take care of is "CASE of the letters in the XML nodes and starting and end tags". Try the following xml string it might help you

var sRepeatingXml = "<my:LogEntries xmlns:my='http://schemas.microsoft.com/office/infopath/2003/myXSD/2005-03-04T02:16:49'><my:name>NameValue</my:name><my:age>Agevalue</my:age><my:LogEntries>";

Agni
InfopathDev India

Re: Inserting into Repeating Table Programmatically

potpourri — Fri, 15 Apr 2005 02:57:34 GMT

Hi Agni,
thanks for the reply.

I've included the code you gave me, but it throws me an error saying something that the element "LogEntries" entered is not as infopath expected due to the namespace naming difference i suppose, even after I setProperty("SelectionNamespaces",...).

The error specified that the parentnode (logGroup) is with a certain namespace and thus expecting "LogEntries" to have the same namespace.

Any idea anyone? :(

--------------------------------------------------------------------------
//write get the XML of repeating node into a string
var sRepeatingXml = "<LogEntries><name>NameValue<name><age>Agevalue</age><LogEntries>";

//create a Dom for the XMLNode
var oXml = XDocument.CreateDOM();

oXml.async = false;
oXml.loadXML(sRepeatingXml);
oXml.setProperty("SelectionNamespaces", "xmlns:my='http://schemas.microsoft.com/office/infopath/2003/myXSD/2005-03-04T02:16:49'");

//Get the Parent of the repeating table
var parentofRepeatingNode = XDocument.DOM.selectSingleNode("/my:myFields/my:logGroup");

//append the repeating XML Element to the Parent node
parentofRepeatingNode.appendChild(oXml.documentElement);
--------------------------------------------------------------------------

Re: Inserting into Repeating Table Programmatically

Agni Jonnalagadda — Thu, 14 Apr 2005 19:41:44 GMT

Here is one way of adding a new row to the repeating table.

//write get the XML of repeating node into a string
string sRepeatingXml = "<LogEntries><name>NameValue<name><age>Agevalue</age><LogEntries>";

//create a Dom for the XMLNode
IXMLDOMDocument oXml = thisXDocument.CreateDOM();
oXml.async = false;
oXml.loadXML(sRepeatingXml);

//Get the Parent of the repeating table
ixmldomNode parentofRepeatingNode = getNode("logGroup/logEntries");

//append the repeating XML Element to the Parent node
parentofRepeatingNode.appendChild(oXml.documentElement);

Agni
InfopathDev India

Re: Inserting into Repeating Table Programmatically

potpourri — Thu, 14 Apr 2005 09:26:44 GMT

oh yeah forgot to mention, i realised i need to use:

XDocument.View.ExecuteAction("xCollection::insert", "<table_name>");

but where/when to specify the field values to be inserted?

Inserting into Repeating Table Programmatically

potpourri — Thu, 14 Apr 2005 07:34:42 GMT

Let say I have the following data source structure:
1. myFields
1.1 logGroup
1.1.1 logEntries (the repeating table)
1.1.1.1 name (the 1st field in the repeating table)
1.1.1.2 age (the 2nd field in the repeating table)

Does anyone know how to insert a row programmatically into a repeating table, such that each row to be inserted into repeating table logEntries contain the field "name" and "age" ?

thank you :)