Asp.net cascading expansion with a difference

Question

Does anyone know a control for asp.net that can achieve this either server or ajax.

I have a hierarchy of school, section and program area. Unfortunately, this hierarchy has such complexities that a program area can appear in more than one school.

As for reporting, I would like to provide end-user options for each hierarchy drop-down list for ANY / ALL. Therefore, if a school is selected, you can still select any unit within this school and the ANY / ALL option, and then the list of program areas will be filtered based on the selected school and ANY / ALL groups.

I hope this makes sense, any questions that I will bring to the editor.

EDIT: I solved it, I realized, I missed the obvious, I put my initial solution out of 3 separate drop-down individual sql queries, requiring input of drop-down lists in the hierarchy. I realized that if I had any character as a% wildcard (sqlserver one or more characters) and changed the value to equal, as I would have achieved the desired effect.

It returns a message, but this is not a problem, it is a very fast set of sql queries.

Answer 1

The ASP.NET AJAX Control Toolkit has a cascading drop-down list that uses the web service interface to determine which data will populate the next data drop-down list. I could easily see that you are using this control so that your web service either returns a specialized subset if a specific element is selected or returns a full set of parameters if ANY / ALL is selected.

Is this what you are looking for?

Answer 2

the options displayed in the drop-down list are controlled by the XML support of the control. If you include all possible values ​​in the "ANY" selection box, they will be displayed in the control.

The real answer should be how much data and how many possible combinations will there be? If the number is minimal and can be predicted, you should make this XML file.

This is a large number, or not just predicted, and what you are really looking for is “advanced search” type functionality, which should be very easy to do with the selectbox control.