Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>When you say your dropdowns are used in several views, do you still consider these dropdowns as part of the view that is rendering them? If so, I think using a custom HTML helper or a partial view (ascx) is appropriate. Then, like you suggest, you can populate the data for the dropdowns using a common service from your domain layer. I think that is a very reasonable approach.</p> <p>However, if you feel the dropdowns are somewhat external/unrelated to the view, then you might find that using Html.RenderAction() gives you a much cleaner result. Using Html.RenderAction(), you can output the result of an Action method directly into any other view. Therefore, you can create 1 controller with the necessary Action method(s) to populate those dropdowns. For example, let say you have a view with roughly something like:</p> <pre><code>&lt;div&gt; &lt;div id="coreView1"&gt; &lt;!-- some view code here --&gt; &lt;/div&gt; &lt;/div&gt; &lt;div id="commonDropdowns"&gt; &lt;% Html.RenderAction("Create", "Dropdown"); %&gt; &lt;/div&gt; </code></pre> <p>where <em>Create</em> is the name of your method in the <em>DropdownController</em>.</p> <p>For example:</p> <pre><code>public class DropdownController : Controller { public ViewResult Create() { // do stuff here to create the ViewResult of the common Dropdowns } } </code></pre> <p><strong>Note</strong>: Some people dislike this approach as it doesn't fit the typical MVC seperation of concerns. However, it can be a really great fit for some cases.</p> <p>Hope one of these approaches can help.</p>
    singulars
    1. This table or related slice is empty.
    1. POMVC - How best to organize commonly used drop-down lists in many views
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USChris Melinn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POMVC - How best to organize commonly used drop-down lists in many views
      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
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt should be noted that Html.RenderAction is NOT included with ASP.NET MVC 1.0. It is a seperate Add-On. http://eduncan911.com/blog/html-renderaction-for-asp-net-mvc-1-0.aspx But, it will be included with ASP.NET MVC 2.0 Beta (finally!).
      singulars
      1. PO
      1. USeduncan911
    2. COThanks eduncan, good point! Some info and references here: http://davidhayden.com/blog/dave/archive/2009/04/04/ASPNETMVCPartialViewsHtmlRenderActionASPNETMVCFutures.aspx
      singulars
      1. PO
      1. USChris Melinn
    3. COThank you for your replies. I am in MVC1. I may have to port it to MVC2 and try out. But despite that in MVC1, I have gone the route of organizing \Model\CommonQueries and use that in those in the views where the dropdown is used and the view where it is maintained. Trying to get cascading to work with webservice now but that is not working out. Going the route of JSON now. It's fun fun fun. Thanks again.
      singulars
      1. PO
      1. USab.
 

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