Newbie Questions

Re: Set Value of Drop-Down List Box to Item #1

ben.lenihan — Fri, 27 Aug 2010 15:41:09 GMT

Helped me too

Thanks a million

Re: Set Value of Drop-Down List Box to Item #1

Greg Collins — Wed, 04 Jun 2008 17:55:09 GMT

Sure thing. Glad to help!

Re: Set Value of Drop-Down List Box to Item #1

fijaz — Mon, 12 May 2008 08:48:05 GMT

Greg Collins:

The problem you are having might be coming from the xsi:nil attribute.

On non-String data type nodes (including, but not limited to: Date, Time and DateTime nodes), if you want to allow the node to have a blank value, the schema places the attribute: xsi:nil="true" on the node. While this attribute is present on the node, the node value MUST, I repeat, MUST be blank. To set a value on such a node, you must first remove that attribute.

Later, if you clear the value, and you don't want the field to be required (i.e. a red asterisk in the view on the field), then you must place that attribute back on the node.

Hopefully this solves your issue.

Yes, this was the problem. Thanks for the help.

Re: Set Value of Drop-Down List Box to Item #1

Michael Vasquez — Fri, 09 May 2008 23:45:07 GMT

Found my problem.

Old code:

xnMyForm.SelectSingleNode("/my:SharePointTraining/my:directorate", ns).SetValue("") Don't work

New Code:

xnMyForm.SelectSingleNode("/my:SharePointTraining/my:Directorate", ns).SetValue("") Works.

Notice the capital "D" in directorate. Did not realize that this is case sensitive. Someone told me that xPathNavigator is case sensitive.

Mike

Re: Set Value of Drop-Down List Box to Item #1

Greg Collins — Fri, 09 May 2008 23:17:45 GMT

The problem you are having might be coming from the xsi:nil attribute.

On non-String data type nodes (including, but not limited to: Date, Time and DateTime nodes), if you want to allow the node to have a blank value, the schema places the attribute: xsi:nil="true" on the node. While this attribute is present on the node, the node value MUST, I repeat, MUST be blank. To set a value on such a node, you must first remove that attribute.

Later, if you clear the value, and you don't want the field to be required (i.e. a red asterisk in the view on the field), then you must place that attribute back on the node.

Hopefully this solves your issue.

Re: Set Value of Drop-Down List Box to Item #1

fijaz — Fri, 09 May 2008 06:28:05 GMT

Greg Collins:

.SetValue() is the right choice... but DateTime.Today.ToString() fails to give an XML-compatible date string.... XML expects the format of the string to be "YYYY-mm-DD", which you can get from a slight modification of your code: DateTime.Today.ToString("s"). The "s" tells the string generator to use the "s"ortable string format, which is, in fact, the XML format.

Thanks, but still getting the same error shown below, also tried hardcoded date as .SetValue("2008-05-08").

System.InvalidOperationException
Schema validation found non-data type errors.
   at Microsoft.MsoOffice.InfoPath.MsxmlInterop.MsxmlDocument.ThrowExceptionFromMsxmlInteropError(MsxmlInteropError eError)
   at Microsoft.MsoOffice.InfoPath.MsxmlInterop.MsxmlDocument.ThrowExceptionFromHresult(Int32 hrError)
   at Microsoft.MsoOffice.InfoPath.MsxmlInterop.MsxmlNodeImpl.set_Text(String strText)
   at Microsoft.Office.InfoPath.MsxmlNavigator.SetValue(String value)

Re: Set Value of Drop-Down List Box to Item #1

Greg Collins — Thu, 08 May 2008 23:26:33 GMT

.SetValue() is the right choice... but DateTime.Today.ToString() fails to give an XML-compatible date string.... XML expects the format of the string to be "YYYY-mm-DD", which you can get from a slight modification of your code: DateTime.Today.ToString("s"). The "s" tells the string generator to use the "s"ortable string format, which is, in fact, the XML format.

Re: Set Value of Drop-Down List Box to Item #1

fijaz — Thu, 08 May 2008 08:16:08 GMT

Hi,

I want to assign a date value to DatePicker control (DateTime Data type) on my form. I have tried it using

xnMyForm.SelectSingleNode("/my:Main/my:LeaveStartDate", ns).SetValue(DateTime.Today.ToString());

But it gives following exception:

I also tried

xnMyForm.SelectSingleNode("/my:Main/my:LeaveStartDate", ns).SetTypedValue(DateTime.Today);

and it returned following exception:

System.NotImplementedException
The method or operation is not implemented.
at Microsoft.Office.InfoPath.MsxmlNavigator.SetTypedValue(Object typedValue)

Any help?

Re: Set Value of Drop-Down List Box to Item #1

Greg Collins — Tue, 06 May 2008 23:25:59 GMT

Yes, all C# code is case sensitive. Hard lesson, but you'll not forget. Glad you got it working.

Re: Set Value of Drop-Down List Box to Item #1

Michael Vasquez — Tue, 06 May 2008 20:02:07 GMT

I did not realize the XPathNavigator is case sensitive. I did the following and it works, xnMyForm.SelectSingleNode("/my:SharePointTraining/my:Directorate", ns).SetValue("")

Thanks,

Mike

Re: Set Value of Drop-Down List Box to Item #1

Michael Vasquez — Tue, 06 May 2008 19:29:36 GMT

Still does not work. Your code return the MessageBox.Show("Failed to select")

This is just a drop-down box and I want to reset it to the first item in the list, which is blank. I can submit the form with no problems but I just want to set the field to blank. All the test boxes work because they are simple text boxes, but it seems that if the text box is something else, InfoPath chokes. There has to be an answer.

Thanks,

Mike

Re: Set Value of Drop-Down List Box to Item #1

Greg Collins — Wed, 30 Apr 2008 19:37:04 GMT

That kind of error message indicates that the select statement failed to retreive a valid node.

You might try breaking out your statement to see if the selection failed (or walk through it in the debugger):

XPathNaviagor test = xnMyForm.SelectSingleNode("/my:SharePointTraining/my:directorate", ns);
if(test != null)
test.SetValue("")
else
MessageBox.Show("Failed to select");

Re: Set Value of Drop-Down List Box to Item #1

Michael Vasquez — Tue, 29 Apr 2008 20:44:55 GMT

my:directorate is a drop-down list box and the data type is string which points to a SharePoint list that contains a list of all the directorates.

The error is NullReference Exception

The message is "Message="Object reference not set to an instance of an object."

Re: Set Value of Drop-Down List Box to Item #1

Greg Collins — Tue, 29 Apr 2008 20:29:43 GMT

What is the data type of my:directorate?

What is the error message you are getting?

Is that node even present in the XML when you try to set it's value?

Set Value of Drop-Down List Box to Item #1

Michael Vasquez — Tue, 29 Apr 2008 20:17:41 GMT

I am using VSTA on a InfoPath form and I want to set a value on a listbox to the first list item. This list box is retrieving items from a list box on the SharePoint Site.

What I am doing is I have a form that gets the userinfo from Active Directory and populates the form. There are three items that initially I have to set manually, Directorate, Department, Division. When I submit the form, all fields populate my list at my SharePoint site. This works. I am working on clearing the form using vb.net. If a textbox is just a string textbox, it works, but errors when I try to set the Drop-Down List Box to "" or the first item in the list, which is blank. Here is what I have so far.

Dim xnMyForm As XPathNavigator = Me.CreateNavigator()
Dim ns As XmlNamespaceManager = Me.NamespaceManager

xnMyForm.SelectSingleNode("/my:SharePointTraining/my:fname", ns).SetValue("") 'WORKS
xnMyForm.SelectSingleNode("/my:SharePointTraining/my:lname", ns).SetValue("") 'WORKS

xnMyForm.SelectSingleNode("/my:SharePointTraining/my:directorate", ns).SetValue("") 'DOES NOT WORK

TIA

Mike