Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>An approach you could take is to extract the drop down list values into a viewmodel of their own. So:</p> <p><strong>Step 1:</strong> Create a view model (<code>ItemsViewModel</code>) that encapsulates the drop down list items:</p> <pre><code>using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.Linq; using System.Web; using System.Web.Mvc; namespace Models { public class DropDownListItem { public string Text { get; set; } public string Value { get; set; } } public class ItemsViewModel { private readonly List&lt;DropDownListItem&gt; _items; // The selected item: public string SelectedItem { get; set; } // The items: public IEnumerable&lt;SelectListItem&gt; Items { get { var allItems = _items.Select(i =&gt; new SelectListItem { Value = i.Value, Text = i.Text }); return DefaultItem.Concat(allItems); } } // Default item (i.e. the "select" text) if none selected public IEnumerable&lt;SelectListItem&gt; DefaultItem { get { return Enumerable.Repeat(new SelectListItem { Value = "-1", Text = "Select an item" }, count: 1); } } public ItemsViewModel() { } // Constructor taking in items from service and selected item string: public ItemsViewModel(List&lt;DropDownListItem&gt; items, string selected) { _items = items; SelectedItem = selected; } } } </code></pre> <p><strong>Step 2:</strong> Create a partial view in the Views folder that binds to the <code>ItemsViewModel</code>:</p> <pre><code>@model Models.ItemsViewModel @Html.DropDownListFor(m =&gt; m.SelectedItem, Model.Items) </code></pre> <p><strong>Step 3:</strong> In the appropriate controller (e.g. HomeController), place the child action that pulls the data from the service, the view model and the partial view together:</p> <pre><code>[ChildActionOnly] public ActionResult DropDownList(string type, string selected) { // If you need to call different services based on the type (e.g. Country), then pass through "type" and base the call on that var items = new ItemsViewModel( (from g in _service.getTitles() select new DropDownListItem { Text = g.Text, Value = g.Value }).ToList(), selected); return PartialView("DropDownPartial", items); } </code></pre> <p><strong>Step 4:</strong> Drop this line of code into the view where you need the drop down list:</p> <pre><code>@Html.Action("DropDownList", "Home", new { selected = "2", type = "country" }) </code></pre> <p>Note that <code>selected</code> and <code>type</code> are to be determined whichever way you see fit and are optional.</p> <p>Hopefully this gives you some inspiration.</p>
    singulars
    1. This table or related slice is empty.
    1. POusing a viewmodel to assign values from a soap web service to a dropdownlist
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCryoFusion87
    1. USAlistair Findlay
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POusing a viewmodel to assign values from a soap web service to a dropdownlist
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COthanks for that I have got it working for one service but I am have some difficulty working out how to get it works with a second service so far it works for titles but I am trying to get it to work with a second service for Lead Sources how do I pass this type?
      singulars
      1. PO
      1. USCryoFusion87
    2. COhave edited your code to show what I currently have
      singulars
      1. PO
      1. USCryoFusion87
    3. COOK, so the Step 4 bit would look something like `@Html.Action("DropDownList", "Home", new { selected = "2", type = "leadsources" })`. Then in Step 3, you can do something like `if (type == "leadsources")` etc. to call the different service.
      singulars
      1. PO
      1. USAlistair Findlay
 

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