Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>Basic Friendly names</strong></p> <p>Use the <a href="http://blogs.msdn.com/abhinaba/archive/2005/10/20/c-enum-and-overriding-tostring-on-it.aspx" rel="noreferrer">Description attribute:</a>*</p> <pre><code>enum MyEnum { [Description("This is black")] Black, [Description("This is white")] White } </code></pre> <p>And a handy extension method for enums:</p> <pre><code>public static string GetDescription(this Enum value) { FieldInfo field = value.GetType().GetField(value.ToString()); object[] attribs = field.GetCustomAttributes(typeof(DescriptionAttribute), true); if(attribs.Length &gt; 0) { return ((DescriptionAttribute)attribs[0]).Description; } return string.Empty; } </code></pre> <p>Used like so:</p> <pre><code>MyEnum val = MyEnum.Black; Console.WriteLine(val.GetDescription()); //writes "This is black" </code></pre> <p>(Note this doesn't exactly work for bit flags...)</p> <p><strong>For localization</strong></p> <p>There is a well-established pattern in .NET for handling multiple languages per string value - use a <a href="http://www.codeproject.com/KB/dotnet/Localization.aspx" rel="noreferrer">resource file</a>, and expand the extension method to read from the resource file:</p> <pre><code>public static string GetDescription(this Enum value) { FieldInfo field = value.GetType().GetField(value.ToString()); object[] attribs = field.GetCustomAttributes(typeof(DescriptionAttribute), true)); if(attribs.Length &gt; 0) { string message = ((DescriptionAttribute)attribs[0]).Description; return resourceMgr.GetString(message, CultureInfo.CurrentCulture); } return string.Empty; } </code></pre> <p>Any time we can leverage existing BCL functionality to achieve what we want, that's definitely the first route to explore. This minimizes complexity and uses patterns already familiar to many other developers.</p> <p><strong>Putting it all together</strong></p> <p>To get this to bind to a DropDownList, we probably want to track the real enum values in our control and limit the translated, friendly name to visual sugar. We can do so by using an anonymous type and the DataField properties on the list:</p> <pre><code>&lt;asp:DropDownList ID="myDDL" DataTextField="Description" DataValueField="Value" /&gt; myDDL.DataSource = Enum.GetValues(typeof(MyEnum)).OfType&lt;MyEnum&gt;().Select( val =&gt; new { Description = val.GetDescription(), Value = val.ToString() }); myDDL.DataBind(); </code></pre> <p>Let's break down that DataSource line:</p> <ul> <li>First we call <code>Enum.GetValues(typeof(MyEnum))</code>, which gets us a loosely-typed <code>Array</code> of the values</li> <li>Next we call <code>OfType&lt;MyEnum&gt;()</code> which converts the array to an <code>IEnumerable&lt;MyEnum&gt;</code></li> <li>Then we call <code>Select()</code> and provide a lambda that projects a new object with two fields, Description and Value.</li> </ul> <p>The DataTextField and DataValueField properties are evaluated reflectively at databind-time, so they will search for fields on DataItem with matching names.</p> <p>-<em>Note in the main article, the author wrote their own <code>DescriptionAttribute</code> class which is unnecessary, as one already exists in .NET's standard libraries.</em>-</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to have userfriendly names for enumerations?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USpodiluska
    1. USRex M
    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. COFor localization, you might skip the description attributes and just use "MyEnum.Black" and "MyEnum.White" as the resource names.
      singulars
      1. PO
      1. USstevemegson
    2. CO@stevemegson that would definitely work! I'm a big SoC/SRP purist though, and to me double-purposing the enum as both a programmatic value and a multi-language resource key sets off warning bells :)
      singulars
      1. PO
      1. USRex M
    3. COHi, What I would like to accomplish is to use a binding like comboComplexity.DataSource = Enum.GetValues(typeof(Complexity)); But using this I still get in the combo the names of the enumeration values, and not their descriptions Also, I renamed GetDescription to ToString(), hoping that combo will use that for enum name, but no luck Any suggestion? Thanks
      singulars
      1. PO
      1. USbzamfir
 

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