C# - Populating Dropdownlist Using MVC2 Based On Another Dropdownlist (Cascading)
Sep 18, 2010
I am making an application that deals with vehicles. I need two DropDownLists:
Makes: All Vehicle Makes
Models: Models that belong to the selected value of the Make DropDownList
How is this done in MVC2? My Idea: Do I use an ajax call when my first list is selected and then pull back the Models to bind to the Model DDL? How would model binding come into play that way? UPDATE I posted what I ended up doing as an answer. It is super simple and works great. You can use a get too if you feel so inclined, but you have to specify that you want to like so... return Json(citiesList, JsonRequestBehavior.AllowGet);
I am having two dropdownlist in my project,one dropdownlist for empid, another dropdownlist for month, if the user select the empid, the values are retrieved in the textbox.
In the second dropdownlist, if the user select the month in the dropdownlist it will display the leave details, its all working fine, if the user again select the first dropdownlist that means empid, I want to show the second dropdownlist as select month, how can do this.....
I have one table which contains branch codes(primary key), Branch name and bank name columns. I have 3 dropdownlist boxes. the first dropdownlist is for the branch codes. When i select the a branch code i need the second dropdownlist box to populate with the appropriate branch name and the third dropdownlist box to populate the bank name at the same time.
Is it possible to have one table like mine and acheive this, if so how do i go about doing this?
I did read up on this but only came across ones with 3 tables.
I am having a problem with disabling DropDownList based on the chice of 1st DropDownList, there is no post back occuring, and it is a template based web app here is the current code:
what is happening now is page is blank and if I remove the above code everything shows, where I am going wrong. here is the plain and final javascript code which worked:
what i m trying is i hav two dropdownlists inside the gridview... namely say ddonsiteoffsite and ddhours... now what i want is if the selectedtext of ddonsiteoffsite is "onsite" the ddhours should b disabled... i tried the code snippet but ... its not disabling the ddhours... can someone help me please..
there is a radio button, a dropdownlist. radiobuttons are OY, OTY,VDA ( in my database there are fields named OY.OTY,VDA) if i select OY in my radio button the data should be displayed from field OY in dropdownlist and if i select OTY in my radio button the data should be displayed from OTY field in dropdownlist is it possible. there is a sqldatasource for dropdownlist .
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MS16ConnectionString %>" SelectCommand="SELECT DISTINCT OY FROM COURSE_INTAKE"> </asp:SqlDataSource>
THE SELECTED DROPDOWNLIST DATA IS REQUIRDE TO BE DISPLYED IN A GRIDVIEW.
I've spent the majority of the past week knee deep in the new templating functionality baked into MVC2. I had a hard time trying to get a DropDownList template working. The biggest problem I've been working to solve is how to get the source data for the drop down list to the template. I saw a lot of examples where you can put the source data in the ViewData dictionary (ViewData["DropDownSourceValuesKey"]) then retrieve them in the template itself (var sourceValues = ViewData["DropDownSourceValuesKey"];) This works, but I did not like having a silly string as the lynch pin for making this work.
I am getting a problem while working with the Dropdownlist in VS2008. I am trying to populate the DDL using c# codding instead of creating DataSource in GUI. The DDL is getting populated as expected, but then I've added a label that will show the current selected item; for this I've written a code in DropDownList1_SelectedIndexChanged() :
I hae also enable AutoPostback for the DDL. I have placed the PopulateDDL() method inside of the Page_Load(); But whenever I select a item, it's always giving only the first item's name as the Lebel.Text. But when I use GUI and ceate a SqlDataSource and attach that to the DDL all works fine. What to do??
I'm new to MVC pattern and I have a question regarding to a dropdownlist. Actually My Data came from a collection (random string) then it displays it in a list. And yes it display, so I add a dropdownlist. And I can populate it using the same collection. My question is how can I populate the dropdownlist from different collection?
so I am having an issue getting a drop down list to choose the right value when it renders. It always defaults to index zero. However, I do have a view in another place where it renders just fine and selects the right value. I don't understand the difference.
Here is a trimmed down version of the view that works correctly:
@model AppName.Models.Guest @using (Html.BeginForm()) { Attending Ceremony?<br /> @Html.DropDownListFor(x => x.ConfirmCeremony, new SelectList(new Dictionary<string, string> { {"No Answer", "No Answer"},
Using MVC2, I want to know how you add the options of a dropdownlist from a database. I have several lookup lists so I will need to do this many times. I'm stuck on part 5 of the MusicStore (which is using MVC3) at this part
[Code]....
Alternatively if someone could recommend an MVC2 tutorial which covers drop lists.
I have code that populates 2 dropdownlist in a gridview. DropStart And DropEnd I want to add time values depending on a few things here's the routine I cal.
Code:
Public Sub GenerateTime(RowIndex As Integer) Dim ComboStart As New DropDownList Dim ComboEnd As New DropDownList Dim ItemList As ListItem Dim TimeInterval As Integer Dim IntervalleCalcul As Integer Dim NombreIntervalles As Integer
[code]....
now this code is called, and runs fine, it goes in the for loop and I see if I trace it that combostart and comboend both have 96 Items in them as expected. hence it did find the controls in the gridview. but when I exit this sub and continue the code by just running the code in the asp.net page the two corresponding dropdown control don't get the values that did get added in the code behind.
In the RowEditing is when I call this routine.
Code:
Private Sub GridDetails_RowEditing(sender As Object, e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridDetails.RowEditing
GridDetails.EditIndex = e.NewEditIndex GridDetails.DataBind() GenerateTime(GridDetails.EditIndex) End Sub
How I populate a dropdownlist from code behind. I want to add the items from an access database. I know how to read the rows but don't know how I add them to the dropdownlist. What I mean by this is I need to add a value column and a display column because I want to save the code value not the display value.
I have a .aspx page having two dropdowns, the data to be loaded in them is usually static(but may change everyday), the first dropdown always displays the main categories and the second dropdown is initially empty.
Now, the requirement is:
As the user selects a category from the first dropdownlist, the second dropdownlist should populate based on the selection just made.
The road-block:
This should be done without a postback. My boss wants something like the drop downs on this page.
So what I gather is, I'd have to retrieve the data from the database on page load event, store it in the cache(or somewhere else?), then use javascript to handle the selectedindexchanged event of the 1st dropdown, use the data from database stored at pageload and populate the second dropdown according to the selected value of first dropdown.
P.S.- I'm a beginner ASP.Net C# programmer and have no knowledge of Javascript.
Here is the code from a datagrid edit command in which I am attempting to populate a DropDownList in the EditTemplate from the database. The result is only one item (the first) from the database, instead of all items.
To speed things up for the visitor of my web page, I put a personalised dropdownlist in a session variable (as below).
The idea is that if the user is logged in and the ddl session variable is Nothing then it should be set here, and the next times the dropdownlist should be set from this session variable.
The session seems to be populated ok, but the resulting dropdownlist (ddlMenu) doesn't (it just becomes blank). I suspect that it has soemething to do with the way I try to assign it. No matter what I try I run into problems, saying that one thing is a one-dimensional array and the other thing a listitemcollection, or the like. What should I write in the last line?
If Session("aid") IsNot Nothing And Session("ddl") Is Nothing Then Dim ddlny As New DropDownList ddlny.Items.Add(New ListItem(vstr, "")) ddlny.Items.Add(New ListItem(kontrstr, "PageA.aspx")) ddlny.Items.Add(New ListItem(bstr, "PageB.aspx")) If dt IsNot Nothing Then 'dt is a datatable, populated elsewhere For i As Integer = 0 To dt.Rows.Count - 1 ddlny.Items.Add(New ListItem(dt.Rows(i).Item("name"), dt.Rows(i).Item("did"))) Next End If Session("ddl") = ddlny End If ddlMenu.Items.Clear() ddlMenu = Session("ddl") 'THIS IS THE LINE THAT SHOULD BE REWRITTEN.
I am trying to populate (store) an access database with the information from a DropDownList.
At the moment i have a form where the user inputs data into a textbox and on sumbission it adds to the access database. I am unsure how to add data to the database from the selections choosen in the DropDownList. I have a DropDownList for Title e.g. Mr,Mrs,Ms,Miss.
I have provided the code that populates the database from the TextBox's
