Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You could use AJAX. subscribe to the change event of the dropdownlist and trigger an AJAX request to a controller action passing along the selected category. The action will query the database for corresponding subcategories and return a partial view with corresponding checkboxes which will be injected into the DOM.</p> <p>So let's suppose that you already have a dropdownlist for the categories in your view:</p> <pre><code>@Html.DropDownListFor( x =&gt; x.CategoryId, Model.Categories, new { id = "categories", data_subcategoriesurl = Url.Action("subcategories", "somecontroller") } ) </code></pre> <p>and some div which will contain the subcategories somewhere on the page:</p> <pre><code>&lt;div id="subcategories"&gt; @Html.EditorFor(x =&gt; x.SubCategories, "SubCategories") &lt;/div&gt; </code></pre> <p>and you could then have a <code>SubCategories.cshtml</code> partial which will render the list of checkboxes:</p> <pre><code>@model IList&lt;CategoryViewModel&gt; @{ // we change the HTML field prefix so that input elements // such as checkboxes have correct names in order to be able // to POST the values back ViewData.TemplateInfo.HtmlFieldPrefix = "SubCategories"; } @for (var i = 0; i &lt; Model.Count; i++) { &lt;div&gt; @Html.LabelFor(x =&gt; x[i].IsSelected, Model.CategoryName) @Html.CheckBoxFor(x =&gt; x[i].IsSelected) &lt;/div&gt; } </code></pre> <p>Now you could subscribe to the change event of the dropdown in a separate javascript file:</p> <pre><code>$(function() { $('#categories').change(function() { var subcategoriesUrl = $(this).data('subcategoriesurl'); var selectedCategoryId = $(this).val(); $('#subcategories').load(subcategoriesUrl, { id: selectedCategoryId }); }); }); </code></pre> <p>and finally the <code>SubCategories</code> action which will be invoked with AJAX:</p> <pre><code>public ActionResult SubCategories(int? id) { var subCategories = Repository.GetSubCategories(id); return View(subCategories); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHo to display multiple checkbox selection based on user's selection from dropdown?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDarin Dimitrov
    1. USDarin Dimitrov
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHo to display multiple checkbox selection based on user's selection from dropdown?
      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. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI am making restful call on my application to get categories & subcategories so what would be best approach to get them and show dropdown for categories? Can you explain after i get the jason response i will deserialize that object, then how should i get the category/subcategory values to my viewmodel, so i can display them when user calls(GET) the page where these categories will be displayed along with other textbox, and once the user submit the form then it posts all selection along with other textbox values.
      singulars
      1. PO
      1. USupdev
    2. CO@updev, there are 2 possible approaches here: either you use AJAX to query your RESTful service which will return JSON and then fill the dropdown options (which will initially be rendered empty), or have your controller action query the service or directly a repository to fill a view model that will be passed to the view and then rendered as a dropdown list using the DropDownListFor helper (it's what I have shown in my answer). As far as the sub categories is concerned using AJAX seems like a necessity since you want to refresh this list of checkboxes everytime when the selection changes.
      singulars
      1. PO
      1. USDarin Dimitrov
    3. COcan you help with defining Model/ViewModel for this scenario?
      singulars
      1. PO
      1. USupdev
 

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