InfoPath Dev

Within infopath form I have fields that are stored on the SQL Datbase. No problem. Using this assistance http://weblogs.asp.net/jan/archive/2004/03/16/90533.aspx I have a dropdown list of all the users of a Site bound to "SubmittedBy". (this dropdown list is an XML file)

Now I have done a simple "Test" button (using vb.net) to Alert who the currently selected user is. (I open the form, select a user from the drop down list and press "Test")

Here's the code:

<InfoPathEventHandler(MatchPath:="BTN_TEST", EventType:=InfoPathEventType.OnClick)> _
Public Sub BTN_TEST_OnClick(ByVal e As DocActionEvent)
    ' Write your code here.
    Try
        Dim cVal = thisXDocument.DOM.selectSingleNode("//d:TrRevCostMain/SubmittedBy")
        If Not cVal Is Nothing Then
            thisXDocument.UI.Alert(cVal.text)
        Else
            thisXDocument.UI.Alert("Not Selected")
        End If
    Catch ex As Exception
                thisXDocument.UI.Alert(ex.Message)
    End Try
End Sub

For the N'TH Time, it always alerts "Not Selected", no matter if I select a user in the dropdown list or not. So the condition (Not cVal Is Nothing) is ALWAYS TRUE, cVal is ALWAYS 'Nothing'

I have tried to retreive other element values from the form, eg simple text boxes which are returned correctly.

Any idea why? It seems so difficult to retrieve a simple value from a drop down list?

This is driving me c.r.a.z.y

Thanks.

:)

Change

Dim cVal = thisXDocument.DOM.selectSingleNode("//d:TrRevCostMain/SubmittedBy")

To

Dim cVal = thisXDocument.DOM.selectSingleNode("//d:TrRevCostMain/d:SubmittedBy")

---------------
Matt Faus

Sorry, not working either. I have tried all possible pathnames, with all kinds of .nodename .nodetype .nodetypedvalue .nodetypestring .nodevalue - all without any success.

The thing thats cra**ing out is check for Nothing, it Always is True, ie, the cVal is Always Nothing. Very Very strange.

When I simply alert other form text box directly, without checking for "Nothing" they are alerted correctly.

If I try to retrieve other form text boxes through this code even they are getting "Nothing".

So now I suspect setting the correct Namespace.

Is this a bug, the dropdown list is a secondary source, have others been able to get a value of selected dropdown list, when it is a secondary source from xml file?

Am I totally of track here?

Thanks.

I think I am ready to *** myself.

In the database field was named as SubmitttedBy

In my vbcode I was checking against SubmittedBy

Notice a missing 't'

Anyways here is the code thats working for me now

  <InfoPathEventHandler(MatchPath:="BTN_TEST", EventType:=InfoPathEventType.OnClick)> _
  Public Sub BTN_TEST_OnClick(ByVal e As DocActionEvent)
   ' Write your code here.
   Try
    Dim cNode As IXMLDOMNode = thisXDocument.DOM.selectSingleNode("//d:TrRevCostMain")
    Dim cVal = cNode.attributes.getNamedItem("SubmittedBy")
    If Not cVal Is Nothing Then
     thisXDocument.UI.Alert(cVal.text)
    End If
   Catch ex As Exception
    thisXDocument.UI.Alert(ex.Message)
   End Try
  End Sub

Thanks

Ouch. At least you learned a lesson.

---------------
Matt Faus