Databases
StackOverflow2013
Postsdbo
POhandling dropdown list
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhandling dropdown list
    primarykey
    data
    text
    <p>i´m new developing on asp.net mvc, and even newer using jquery, so this is my problem: i have a few dropdown list that are filled dinamically using the data of another dropdown or textbox, and the data of those drop down is used for another drop down, like a chain, my problem rigth now is that the dropdown sometimes just have one answer/option, and if i try to select that option jquery doesn´t activate the $("#anything").change() event, 'cause i have just one option, how i handle it?</p> <p><a href="http://imageshack.us/photo/my-images/20/sinttulolp.jpg/" rel="nofollow">http://imageshack.us/photo/my-images/20/sinttulolp.jpg/</a></p> <p>for example this i need the data of the red circle for filling the blue circle, but the red circle just have one option and if i click nothing happens</p> <p>code:</p> <p>$(document).ready(function() {</p> <pre><code> $("#tbClave1").autocomplete({ minLength: 1, source: getClave1, select: function(event, ui) { updateClave2(ui.item.value); } }); $("#tbClave1").change(function() { if ($("#tbClave1").val().length == 4) { updateClave2($("#tbClave1").val()); } }); $("#ddClave2").change(function() { updateClave3($("#tbClave1").val(), $("#ddClave2").val()); updateNombre($("#tbClave1").val(), $("#ddClave2").val()); if ($("#ddTipoArticulo").val() == "A" || $("#ddTipoArticulo").val() == "B" || $("#ddTipoArticulo").val() == "L") { updatePrecioA($("#tbClave1").val(), $("#ddClave2").val()); } else { if ($("#ddTipoArticulo").val() == "N" || $("#ddTipoArticulo").val() == "H"){ updatePrecioB($("#tbClave1").val()); } } }); $("#ddClave3").change(function() { updateClave4($("#tbClave1").val(), $("#ddClave2").val(), $("#ddClave3").val()); }); }); </code></pre> <p>Edit: example of how i fill one of the dropdownlist</p> <p>Jquery</p> <p>function updateClave2(cod) {</p> <pre><code> var dd = document.getElementById("ddClave2"); dd.options.length = 0; dd.options[0] = new Option("Espere..."); dd.selectedIndex = 0; dd.disabled = true; codigo = cod; tipoArt = $("#ddTipoArticulo").val(); // Control de errores $("#ddClave2").ajaxError(function(event, request, settings) { dd.options[0] = new Option("No se Cargaron Datos"); }); // Obtenemos los datos... $.ajax({ url: '/Home/GetClave2', dataType: 'json', data: { words: codigo, tipoArticulo: tipoArt }, success: function(data, textStatus, jqXHR) { $.each(data, function(i, item) { dd.options[i] = new Option(item["clave2"], item["clave2"]); }); dd.disabled = false; } }); } </code></pre> <p>Controller</p> <p>public ActionResult GetClave2(string words, string tipoArticulo){ List mySource = miConexion.Clave2(username, password, words, tipoArticulo); return Json(mySource); }</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAlejandro Hinestrosa
    1. USAlejandro Hinestrosa
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhy not put a "Select One" option in the dropdown and make it required? This way, it triggers a selection change event.
      singulars
      1. POhandling dropdown list
      1. USAlex Mendez
    2. CO´cause everytime that option is different, its not always the same option, it depends of previous options, all the three dropdown list u see in the picture are filled dinamically.
      singulars
      1. POhandling dropdown list
      1. USAlejandro Hinestrosa
    3. COYou can have a "Select One" option in each dropdown along with the different options that are in each. So, everytime you select an option in dropdown1, you clear the options on dropdown2, add the Select One option and then the options that are based on dropdown1 selection.
      singulars
      1. POhandling dropdown list
      1. USAlex Mendez
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload