Databases
StackOverflow2013
Postsdbo
POAdd attribute to select list option
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAdd attribute to select list option
    primarykey
    data
    text
    <p>I have a list of items in a drop down list within a Razor view. In the database each item has 3 values associated with it - the database id, short name (for display), and long name (for passing to a service). The drop down must show the short name, so I'm populating the drop down with the database id as the value and the short name as the text.</p> <p>However when a user selects an item I need pass the long name as a query parameter to a search service using jQuery, e.g when Cortina is seleted "Ford Cortina 1979 Blue" needs to be passed to the service. My first thought is store the long name as a data dash attribute but I'm wondering is there a better way. So</p> <ul> <li>How do I store all 3 values in the drop down list? </li> <li>If I do use data dash attributes how do I incorporate all the LONG_NAME values into Html.DropDownListFor or somehow add them to the drop down list?</li> </ul> <p>DB:</p> <pre><code>CARID SHORT_NAME LONG_NAME 1 Viper Dodge Viper 1982 2 Boxster Porsche Boxster 2009 Black 3 Cortina Ford Cortina 1979 Blue </code></pre> <p>Controller helper to create the drop down:</p> <pre><code>public static IEnumerable&lt;SelectListItem&gt; GetSelectList(this IEFRepository repository, string typeName) { var vehicle = repository.TypeTypes.FirstOrDefault(t =&gt; t.Name.ToUpper() == typeName); if (vehicle != null) { var carList = vehicle.SubTypes.ToList().OrderBy(s =&gt; s.Name); var selectList = new SelectList(subTypeList, "SubTypeID", "Name"); return selectList; } } </code></pre> <p>Here's the code I use to create the drop down:</p> <pre><code>&lt;div class="editor-field"&gt; @Html.DropDownListFor(model =&gt; model.CarID, new SelectList(ViewBag.Cars, "Value", "Text", "1")) @Html.ValidationMessageFor(model =&gt; model.CarShortName) &lt;/div&gt; </code></pre> <p>Here's the output:</p> <pre><code>&lt;select id="CarID" name="CarID" data-val="true" data-val-number="The field CarID must be a number." data-val-required="The CarID field is required."&gt; &lt;option value="2"&gt;Boxster&lt;/option&gt; &lt;option value="3"&gt;Cortina&lt;/option&gt; &lt;option selected="selected" value="1"&gt;Viper&lt;/option&gt; &lt;/select&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCiaran Bruen
    1. USCiaran Bruen
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAdd attribute to select list option
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POAdd attribute to select list option
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POAdd attribute to select list option
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI encountered a similar situation. I had to have a dropdown which would allow the user to choose a record in an object graph. There were 4 related tables each with roughly 5 fields. I ended up having to write a javascript API to deconstruct the html generated by DropDownListFor and then kind of re-invent a dropdown in place of the original one. I asked a couple of questions here but never got any good responses and I feel like `DropDownListFor` is kind of a forgotten stepchild in the framework.
      singulars
      1. POAdd attribute to select list option
      1. USTravis J
 

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