Code

Re: How to access form object?

Greg Collins — Wed, 07 Mar 2007 18:40:56 GMT

Correct - rows are dynamic... they can be added, removed, whatever. Or in the case of InfoPath 2007, you can use the horizontal control which allows columns to be dynamic. But there is no control which allows both columns and rows to be dynamic. InfoPath 2003 only supports dynamic rows (unless you hack the XSL to make it dynamic columns).

What you are likely to end up with is a table which has all the required columns (though some might be blank because no values is provided as the column doesn't physically exist in the data), and dynamic rows.

Re: How to access form object?

nukkumatti — Wed, 07 Mar 2007 12:39:59 GMT

Yes you can do that of course. I guess what Greg ment is more that you cannot create any control out of nothing with infopath you can however append new childs to an existing node, see this for example for a repeating section:

string myRepeat	= thisXDocument.DOM.selectSingleNode("my:myFields/my:Result/my:Results").xml;
			IXMLDOMDocument oXml = thisXDocument.CreateDOM();
			oXml.async = false;
			oXml.loadXML(myRepeat);
			IXMLDOMNode parentNode = thisXDocument.DOM.selectSingleNode("my:myFields/my:Result");
			parentNode.appendChild(oXml.documentElement);

But anyway if your repeating table/section is bound to a secondary datasource (database) it will expand automatically.

Does this help ?

Re: How to access form object?

mrudula — Wed, 07 Mar 2007 06:39:38 GMT

Hi Greg,

But then How do I show table data on repeating table or any other control as my table is changing always and want to show data as report.

I want to show data from table on form, I only know the tablename. Table columns are going to change as table changes so I want some datagrid kind of control on InfoPath which will dynamically change columns and rows which would help me to write in less code.

Cannot I add/append child on repeating section and use this child as columns. And then add rows to it which would be same as datagrid then?

Thanks in advance.

Regards,
Mrudula

Re: How to access form object?

Greg Collins — Tue, 06 Mar 2007 20:14:01 GMT

You cannot dynamically add controls to the form. Add it in the designer, and use conditional formatting to choose when to show it.

How to access form object?

mrudula — Tue, 06 Mar 2007 12:43:33 GMT

Hi All,

I am trying to add control on InfoPath form through coding (c# language VSTO) but couldnt do it. I am not able to fetch Active form in the project.

Form frm=Form.ActiveForm; //line 1
frm.Controls.Add(tb);//tb=control object line 2

line1 returns NULL in the frm so couldnt able to add control on the collection of controls on form.

Can you please help me out? Wheather my approach is right or we need to follow some other approach?

Thanks in advance.

Regards,
Mrudula