AJAX :: Cascading Drop Down Based On Multiple Selections
May 14, 2010
Does anyone know if it is possible to have Cascading DropDown Lists which are based on the selected value of more than a single list. Example - I have four tables in a database as follows:
Product
PartA
PartB
PartC
The items in Product are made up by one record from each of the other three tables (PartA + PartB + PartC = Product). What I wish to do is have 3 Cascading DropDown lists which refer to the three individual parts which can be used to select items fromt he Product table.
The first two work no problem but when it comes to the third the list is condition on only items which have the selects of both the first two lists.
I'm seeking to develop Web page that has multiple Drop Down List (3 controls) bind with my database and these controls support AJAX and access my database using LINQ
e.g, when I select one of the control name : Class, then It should access the database then, display the department in this class in the next Drop Dawn List in the next control - ALL this without PostPacking this page and access the my database using LINQ.
I am an newbie to this technology. I had requirement kind of thing, like, I had 5 cascading drop downs, which I created by using ajax control tool kit drop-down extenders, and used web-service to update the cascading drop downs content.
In the same form I need to create a grid, so based upon selection of the user, the grid should change dynamically, like I would like to have some examples kind of things, lets say, I had Four cascading drop- downs, like 1) Vehicles, 2) Hotels 3)Games 4) Year
And those can be sub-categorized to
1) Vehicles ----- Three Wheelers, Two Wheelers, Four Wheelers 2) Hotels -------- Five Star Hotels, Luxurious Hotels, Restaurants, Bars, Pubs 3) Games ------- Play Stations, Video Games 4) Year ----------- Manufactured or established in that particular year
so, If the user selects vehicles, then we need to show all the information regarding vehicles, and if he selects hotels , we need to get the information of vehicles, and hotels( * note, I may not be able to give u the right example, once again i want remind you that these drop downs were cascading drop downs, based upon one selection, other works) and like wise if he selects year, we need to show information of all the things manufactured or established in that particular year and here year is not a cascading drop down, and all these information is maintained in a single database table
And currently I am using Microsoft Sql Server 2008 R2, Visual Studio 2008, Using c#, ( i would be happy, if anyone gives me a code kind of thing, not mandatory, only if possible)...
My question is I have multiple Checkbox Lists and i want to compare it and Filter Datalist records on Checkbox list checked event.. (I want filtering something like [URL]
using System; using System.Collections.Generic; using System.Linq;
[Code].....
My problem is If first checkbox list is checked and user clicks on second checkbox list then i want to compare both checkboxes and populate result based on both checkboxes.
I am using 2 cascading drop down lists in my website. When i test my app on localhost both work perfectly. But after uploading my webapp on the hosting server i receive the following error :
I have a requirement to allow users select multiple "Agencies" and populate the "Types" based on that selection. Cascading Drop down would have been a great fit if there is no mutliple selection involved. I am wondering if I could use a popup dropdown with chekcboxes. However, these checkboxes need to be populated dynamically by a web service. I am not very familiar with AJAX toolkit and what control would work best in this case.
I have several cascading drop down in my website which work fine. The problem is that i know need to use cascading drop down in a modal popup. The first list is populated but the subsequent lists are not being populated.
I am using the AJAX Cascading drop down list but want to add event validation e.g. the compare validators.
As the cascading drop down list requires the page event validation to be disabled what is the best way to do the validation?
Validation Attempt: I have tried to use a custom validator which calls a Javascript function but it doesnt seem to be picking up the control. I get the following error Microsoft JScript runtime error: Object required
function ValidateCostCentCat(source, arguments) { var countryList = document.getElementById("ddlCategory"); if (null != countryList) { var iValue = countryList.options[countryList.selectedIndex].value; if (iValue == "Select Category") { arguments.IsValid = true; } else { arguments.IsValid = false; } } }
The mark-up for the custom validator is
<asp:CustomValidator ID="valcustCategory" runat="server" CssClass="error" Display="Dynamic" ValidationGroup="DirectHire" ClientValidationFunction="ValidateCostCentCat" ErrorMessage="Please select a Cost Centre Category from the drop down list provided.">!</asp:CustomValidator>
I have a page that has a cascading drop down. It works perfectly when I start with an empty page and populate data to save a new row in a db table. However, when I try to load an existing row to the page, the parent is populated, but the child and cdd are not populated. During the load, I set the ccd.selectedvalue to a valid value, but by the time the page is rendered, there is no selection. I am sure it is something simple, but just don't see it.
I have a problem with 3 cascading drop downs. They are on a content page, so I have a Master Page as well. They work just fine but once the user saves the data and then comes back to the same page, I would like to show them what was previously saved. How can I pre-select items in the drop downs that I get from my SQL server db? I tried jquery, javascript, vb code behind and no luck so far. I'm sure i'm doing something wrong. Here is my code:
I've been trying to send my webservice a contextkey for the first drop down. When I debug the webservice, and I manually enter a context key, i get the correct values back with the value that equals my context key having <isDefaultValue>True</isDefaultValue>.
Aspx page:
[Code]....
WebService (part of it that gets data for my first drop down):
[Code]....
[Code]....
Javascript (tried to set the context key here)[Code]....
how do i create a cascading drop-down list without using ajax controls...i am using queries and the language i am using is C# I have a client and a project database....when i choose a client name in the dropdownlist....only the project names associated with that client should appear in the next dropdownlist
I seem to be having a problem loading a gridview using 2 cascading drop down lists. Before I implemented the Ajax cascading drop down list extenders and I just had regular drop down list the gridview that is supposed to load when users choose the appropriate data from the 2 drop down list appears when the submit button was triggered.
[Code]....
When the button event is triggered it looks for the specific value in the second drop down list and calls a specific stored procedure to load the gridview. Now after implementing the cascading drop down lists the page just posts back - there are no errors whatsoever.
I am new to Ajax in general but I have a series of cascading drop down lists that are working fine. I'm using them on a form that I want to be able to either add a new row of data to the database or edit an existing one. I have the insert a new row working but editing an existing one is a bit trickier. The drop down lists are only part of the form but I would like to be able to query for a row id and set their values. Right now I'm querying for a row of data and populating the form with its values on page load and all of the fields work except for the drop down lists. I assume that this is because when the page is loading the web methods haven't run yet to populate the cascading drop downs. Therefore I can't set the selected value because there aren't any values yet. So therefore I'm pretty sure I need to do this from a web method so that it runs after the lists are populated or while the lists are populating but I don't know how.
I am currently building a web site and I utilize cascading drop down lists. I am having difficulty clearing two of my drop downs. The application is utilizing Visual Basis. Here is what I found through my research but they are not resetting my drop downs after a post back:
i followed this tut http://www.ajaxprojects.com/ajax/tutorialdetails.php?itemid=554 for cascading drop downs, but i changed the sql connections for my linq datasource. VS2010 is showing no errors in my code and the page loads fine too, but the two drop down lists are emptycan anyone scan there eyes over it and see if theres any reason why it shouldnt be working?my code is the same as the tuts apart from it uses LINQ instead of SQL
How can I have 2 Cascading Drop Down Lists for the same Drop Down List?here is my problemi have 3 drop down lists read from database1- Schools List 2- Classes List3- Teachers ListEvery School will have more than 1 Class and more than 1 TeacherWhat I want is when user select a School from Schools Drop Down List then BOTH (Classes and Teachers) should be refreshed based on the School Drop Down List
I have 2 dropdowns on my page, i can select from both and complete the other text fields on my form and click my button to submit. But when i receive the email, i get everything from the form, except that the drop down values are coming across as the default value of "0"
Here is my dropdownlist code i have on my page_load to bind them with data when they arrive at the page.
[Code]....
And for the email portion, i am using the selectedvalue as seen below. Thats all i have on the page.. very simple, but only the drop downs are not passing in the email.
ddlCategory.SelectedValue.ToString() and ddlPriority.SelectedValue.ToString()
DropdownList 1 : It is the parent dropdown for dropdownlist 2. Dropdownlist 2 is filtered as soon as any value is selected from dropdownlist 1.
DropownList 2: It contains numeric data which is filtered on the basis of dropdownlist 1 selection.
DropdownList 3: It contains the units for the numeric data displayed in dropdownlist 2. If the user selects some unit in dropdownlist 3, the data in dropdownlist 2 should be filtered accordingly.
let me know whether it is possible to have 2 parents controlling the data in a single cascading dropdown?
I have an ASP.NET (VB.NET) page that uses the Cascading Drop Down extender control. The webservice currently has the datasource (e.g. an XML file) hard-coded, based on the CCD example. What I would like to do now is based on the the logged on user, and their Active Directory credentials (at Page Load) programatically select/define which of multiple XML stored on the server should be used by the CDD control. All of the code-behind has been written already, I'm just having a hard time passing the variable generated during Page Load function to the CDD webservice. (Note: The CDD control loads immediately)
