How do I populate a drop-down list from XML where text = value1 using Visual Basic?

[zerqq]

I have a drop-down list that needs specific values loaded based on the selection of another drop-down list. I tried doing it from sql with \[code\]DISTINCT\[/code\]set but that doesn't return a proper value:\[code\]SELECT DISTINCT RMRP_Label, RMRP_Type FROM Table WHERE RMRP_Type IN (" + search + ")\[/code\]It keeps changing the DropDownList.SelectedItem.Text value for some reason...so I made an XML document:\[code\]<p> <param Name = "Intake_ID" Value = "http://stackoverflow.com/questions/15813390/!hssCombo"></param> <param Name = "Office_ID" Value = "http://stackoverflow.com/questions/15813390/#hssCombo"></param> <param Name = "sub_obj" Value = "http://stackoverflow.com/questions/15813390/%hssCombo"></param> <param Name = "Svc_ID" Value = "http://stackoverflow.com/questions/15813390/!hssCombo"></param>\[/code\]What I need, for instance, is to populate the dropdown with the \[code\]Name\[/code\] value, from this xml where \[code\]Value = "http://stackoverflow.com/questions/15813390/#hssCombo"\[/code\] or rather where \[code\]Value = http://stackoverflow.com/questions/15813390/search\[/code\] as in the select statement