yet another cascading dropdown post

mantisory — Tue, 12 May 2009 13:33:45 GMT

Hi there, I have two dropdowns on my browser based form, one that is a static list of all the sites on my sharepoint server. I would like to bind the second dropdownlist to the subsites for the selected site. I am thinking I can use the GetAllSubWebCollection webservice but am unsure how to bind my second dropdown to it...
I can retrieve the nodelist on the ddlSite_Changed event, and iterate through them to filter them (and create a nodelist or something?) based on the selection...but what do i need to do after that?
Any suggestions would be greatly appreciated.
Byron
p.s. - here is the code I have so far for the site_changed event:

Dim dataSourceName As String = "GetAllSubWebCollection"
Dim curNav As XPathNavigator
Dim xnMain As XPathNavigator = Me.DataSources(dataSourceName).CreateNavigator
Dim nm As XmlNamespaceManager = New XmlNamespaceManager(New NameTable)
nm.AddNamespace("dfs", "http://schemas.microsoft.com/office/infopath/2003/dataFormSolution")
nm.AddNamespace("def", "http://schemas.microsoft.com/sharepoint/soap/")
nm.AddNamespace("tns", "http://schemas.microsoft.com/sharepoint/soap/")
nm.AddNamespace("my", "http://schemas.microsoft.com/office/infopath/2003/myXSD/2009-05-11T16:04:09")
nm.AddNamespace("xsi", "http://www.w3.org/2001/XMLSchema-instance")
Dim xxx As XPathNodeIterator = xnMain.Select("/dfs:myFields/dfs:dataFields/def:GetAllSubWebCollectionResponse/def:GetAllSubWebCollectionResult/def:Webs/def:Web", nm)
Dim s As String
While xxx.MoveNext()
s = xxx.Current.GetAttribute("Url", nm.DefaultNamespace)
If s.Contains(e.NewValue) Then
'what do I do Here?
End If
End While

Browser Forms

yet another cascading dropdown post