InfoPath Dev

I have a text Box whose DataType is set to Whole Number. Now I want to set this textbox programmatically.

The Problem is the SetValue() takes only the string argument. Is there any other method which return whole number or any other datatype. So that Programatically I can bind it the Controls of Different Data types.

XPathNavigator root = MainDataSource.CreateNavigator();

root.SelectSingleNode("/my:myFields/my:field6", NamespaceManager).SetValue("");

// /my:myFields/my:field6 ----> This is Whole Number Data type.I have to set i=10 to it

Please Help, Thanks in Advance

Jayant Sharma

Hi,

Use the following code lines.

XPathNavigator root = MainDataSource.CreateNavigator();

object newValue = 10;

 XPathNavigator node = root.SelectSingleNode("/my:myFields/my:field11", NamespaceManager);

if (node == null || newValue == null)

   return;

string value = newValue.ToString();

 // The xsi:nil needs to be removed before we set the value.

 if ((node.NodeType != XPathNodeType.Attribute) && (value.Length != 0))

 {

     if ((node != null))

       {

           if (node.MoveToAttribute("nil", "http://www.w3.org/2001/XMLSchema-instance"))

                node.DeleteSelf();

       }

  }

node.SetValue(value);

Hi,

Can you try below code.

XPathNavigator root = MainDataSource.CreateNavigator();

            int i = 10; //
            XPathNavigator test = root.SelectSingleNode("/my:myFields/my:field6", this.NamespaceManager);

            test.SetValue(Convert.ToString(i));

But you need to change the Textbox field as string. Otherwise you will get schema validation errors.

A Lot of Thanks... you have solved my big problem...

Is there any condition when we have to reinsert the nillable back to the node. In which case we have to set the nillable attribute to true.

Hi,

Nillable attribute to true is set when the text box data type is numeric and the data in it is empty.

Hi,

Do you want to set the nillable back on the button click or any other case?

Can you give more details about this.

ya exactly, I want to set nillable back to the button. I want to know in which situation we have to set it back. means in which condion we have to set nillable false and true...

Please see this link

http://www.sharepointblogs.com/dooke/archive/2007/08/14/the-xsi-nil-attribute-the-correct-way.aspx

and clerify me the condition in which we have to apply the nillable false

Hi,

When you want to set a value to node of type whole number, date, time, decimal and date and time then you have to set the nil value false. Use the following code lines to set nil to true to the node.

if (node.GetAttribute("nil", "http://www.w3.org/2001/XMLSchema-instance") != null)

{

 if ((node.Value).Length != 0)

 node.SetValue(String.Empty);

if (node.MoveToAttribute("nil", "http://www.w3.org/2001/XMLSchema-instance"))

 node.DeleteSelf();

// Create xsi:nil attribute with the proper namespace.

node.CreateAttribute("xsi", "nil", "http://www.w3.org/2001/XMLSchema-instance", "true");

 }

thanks