XPathNavigator nav = this.CreateNavigator() Q.FileLocation = q.FileLocation + '&FilterField1=Vendor&FilterValue1=' + GetVendorValue() String OriginalFileLocation = string.Copy(q.FileLocation) Public void vendor_Changed(object sender, XmlEventArgs e)įileQuer圜onnection q = (FileQuer圜onnection)this.DataConnections
I'm thinking after doing the q.Execute() I need to somehow update the attributes of the xml to equal the vendor name, but I can't find how to do this.ĭoes anyone have the solution for this, or can point me to the right article? So while the vendor I've picked is 'Company ABC' the value in my secondary datasource is ' 1 #Company ABC'. The last piece of the puzzle is the filter of my dropdown doesn't work because the value I'm filtering on is a lookup field from SharePoint. I found how to retrieve the data as if it were XML ( and created a changed event to re-query using the filter value (code follows). I want to create a cascading dropdown using the value selected from vendor to create the secondary data source from Vendor Equipment. I have two Lists from SharePoint: Vendor & Vendor Equipment. I've found bits and pieces of this all over the internet without the final piece of the puzzle.
