Dynamic / Static items in radComboBox. (SQL Query error)

I am using telerik's rad combo boxes (dropdowns) on my aspx page. there are 3 rad combo boxes and they are cascading dropdowns. the items in the final dropdown is dependent on the selection of the 2nd dropdown. Now, i had to insert a "select all" option in the final dropdown. this being a static value, i added it using "appenddatabounditems" property of the rad combo box, setting it to be true. I can now see the select all option, but the items in the dropdown list are repeated. I have used the distinct keyword in the query. Also, when i make another selection in the 2nd dropdown box, the values in the third dropdown are appended i.e they show "Select all" + items of the previously selected 2nd dropdown option + values of the currently selected dropdown selection.

Am i开发者_Go百科 missing something in the query? or there is something wrong with the telerik controls? or the ajax manager?

PLease help.

Thanks, ghanshyam.

Are you using the EnableLoadOnDemand="true" setting to perform the cascade? The combo box does not clear the old items out automatically. Two things you can do:

• Delete the old items OR
• Bind the entire list to the combo box and hide the invalid ones. This has worked for us when the list is relatively small.

HTH.