Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think I found a little nicer solution to it. EditorFor takes in additionalViewData as a parameter. If you give it a parameter named "htmlAttributes" with the attributes, then we can do interesting things with it:</p> <pre><code>@Html.EditorFor(model =&gt; model.EmailAddress, new { htmlAttributes = new { @class = "span4", maxlength = 128, required = true, placeholder = "Email Address", title = "A valid email address is required (i.e. user@domain.com)" } }) </code></pre> <p>In the template (in this case, EmailAddress.cshtml) you can then provide a few default attributes:</p> <pre><code>@Html.TextBox("", ViewData.TemplateInfo.FormattedModelValue, Html.MergeHtmlAttributes(new { type = "email" })) </code></pre> <p>The magic comes together through this helper method:</p> <pre><code>public static IDictionary&lt;string, object&gt; MergeHtmlAttributes&lt;TModel&gt;(this HtmlHelper&lt;TModel&gt; htmlHelper, object htmlAttributes) { var attributes = htmlHelper.ViewData.ContainsKey("htmlAttributes") ? HtmlHelper.AnonymousObjectToHtmlAttributes(htmlHelper.ViewData["htmlAttributes"]) : new RouteValueDictionary(); if (htmlAttributes != null) { foreach (PropertyDescriptor property in TypeDescriptor.GetProperties(htmlAttributes)) { var key = property.Name.Replace('_', '-'); if (!attributes.ContainsKey(key)) { attributes.Add(key, property.GetValue(htmlAttributes)); } } } return attributes; } </code></pre> <p>Of course you could modify it to render the attributes as well if you are doing raw HTML:</p> <pre><code>public static MvcHtmlString RenderHtmlAttributes&lt;TModel&gt;(this HtmlHelper&lt;TModel&gt; htmlHelper, object htmlAttributes) { var attributes = htmlHelper.ViewData.ContainsKey("htmlAttributes") ? HtmlHelper.AnonymousObjectToHtmlAttributes(htmlHelper.ViewData["htmlAttributes"]) : new RouteValueDictionary(); if (htmlAttributes != null) { foreach (PropertyDescriptor property in TypeDescriptor.GetProperties(htmlAttributes)) { var key = property.Name.Replace('_', '-'); if (!attributes.ContainsKey(key)) { attributes.Add(key, property.GetValue(htmlAttributes)); } } } return MvcHtmlString.Create(String.Join(" ", attributes.Keys.Select(key =&gt; String.Format("{0}=\"{1}\"", key, htmlHelper.Encode(attributes[key]))))); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POTextBoxFor vs EditorFor, and htmlAttributes vs additionalViewData
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USColin Bowern
    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. 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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWould you be so kind as to provide a complete sample project that uses the code you posted? I am new to ASP.NET and at loss where to put that `MergeHtmlAttributes` and `RenderHtmlAttributes` classes.
      singulars
      1. PO
      1. USRosdi Kasim
    2. CO@RosdiKasim - These are extension methods that I typically store in a static class that either mirrors the namespace of the common set of HTML helpers or a new namespace that I include in the web.config in the Views folder so I do not have to keep referencing it on each page. So basically "HtmlHelperExtensions.cs" in the root of the project or an Infrastructure folder.
      singulars
      1. PO
      1. USColin Bowern
    3. COOk thanks. I will give it a try.
      singulars
      1. PO
      1. USRosdi Kasim
 

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