Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>A quick search gave me this:</p> <pre><code>&lt;select name="State"&gt; &lt;option value="" selected="selected"&gt;Select A State&lt;/option&gt; &lt;option value="AL"&gt;Alabama&lt;/option&gt; &lt;option value="AK"&gt;Alaska&lt;/option&gt; &lt;option value="AZ"&gt;Arizona&lt;/option&gt; &lt;option value="AR"&gt;Arkansas&lt;/option&gt; &lt;option value="CA"&gt;California&lt;/option&gt; &lt;option value="CO"&gt;Colorado&lt;/option&gt; &lt;option value="CT"&gt;Connecticut&lt;/option&gt; &lt;option value="DE"&gt;Delaware&lt;/option&gt; &lt;option value="DC"&gt;District Of Columbia&lt;/option&gt; &lt;option value="FL"&gt;Florida&lt;/option&gt; &lt;option value="GA"&gt;Georgia&lt;/option&gt; &lt;option value="HI"&gt;Hawaii&lt;/option&gt; &lt;option value="ID"&gt;Idaho&lt;/option&gt; &lt;option value="IL"&gt;Illinois&lt;/option&gt; &lt;option value="IN"&gt;Indiana&lt;/option&gt; &lt;option value="IA"&gt;Iowa&lt;/option&gt; &lt;option value="KS"&gt;Kansas&lt;/option&gt; &lt;option value="KY"&gt;Kentucky&lt;/option&gt; &lt;option value="LA"&gt;Louisiana&lt;/option&gt; &lt;option value="ME"&gt;Maine&lt;/option&gt; &lt;option value="MD"&gt;Maryland&lt;/option&gt; &lt;option value="MA"&gt;Massachusetts&lt;/option&gt; &lt;option value="MI"&gt;Michigan&lt;/option&gt; &lt;option value="MN"&gt;Minnesota&lt;/option&gt; &lt;option value="MS"&gt;Mississippi&lt;/option&gt; &lt;option value="MO"&gt;Missouri&lt;/option&gt; &lt;option value="MT"&gt;Montana&lt;/option&gt; &lt;option value="NE"&gt;Nebraska&lt;/option&gt; &lt;option value="NV"&gt;Nevada&lt;/option&gt; &lt;option value="NH"&gt;New Hampshire&lt;/option&gt; &lt;option value="NJ"&gt;New Jersey&lt;/option&gt; &lt;option value="NM"&gt;New Mexico&lt;/option&gt; &lt;option value="NY"&gt;New York&lt;/option&gt; &lt;option value="NC"&gt;North Carolina&lt;/option&gt; &lt;option value="ND"&gt;North Dakota&lt;/option&gt; &lt;option value="OH"&gt;Ohio&lt;/option&gt; &lt;option value="OK"&gt;Oklahoma&lt;/option&gt; &lt;option value="OR"&gt;Oregon&lt;/option&gt; &lt;option value="PA"&gt;Pennsylvania&lt;/option&gt; &lt;option value="RI"&gt;Rhode Island&lt;/option&gt; &lt;option value="SC"&gt;South Carolina&lt;/option&gt; &lt;option value="SD"&gt;South Dakota&lt;/option&gt; &lt;option value="TN"&gt;Tennessee&lt;/option&gt; &lt;option value="TX"&gt;Texas&lt;/option&gt; &lt;option value="UT"&gt;Utah&lt;/option&gt; &lt;option value="VT"&gt;Vermont&lt;/option&gt; &lt;option value="VA"&gt;Virginia&lt;/option&gt; &lt;option value="WA"&gt;Washington&lt;/option&gt; &lt;option value="WV"&gt;West Virginia&lt;/option&gt; &lt;option value="WI"&gt;Wisconsin&lt;/option&gt; &lt;option value="WY"&gt;Wyoming&lt;/option&gt; &lt;/select&gt; </code></pre> <p>source: <a href="http://www.geekpedia.com/code55_Drop-down-list-of-US-states.html" rel="nofollow">http://www.geekpedia.com/code55_Drop-down-list-of-US-states.html</a></p> <p>This should allow you to do what you need:</p> <pre><code>List&lt;SelectListItem&gt; states = new List&lt;SelectListItem&gt;(); states.Add(new SelectListItem { value="" selected="selected", text="Select A State"}); states.Add(new SelectListItem { value="AL", text="Alabama"}); states.Add(new SelectListItem { value="AK", text="Alaska"}); states.Add(new SelectListItem { value="AZ", text="Arizona"}); states.Add(new SelectListItem { value="AR", text="Arkansas"}); states.Add(new SelectListItem { value="CA", text="California"}); states.Add(new SelectListItem { value="CO", text="Colorado"}); states.Add(new SelectListItem { value="CT", text="Connecticut"}); states.Add(new SelectListItem { value="DE", text="Delaware"}); states.Add(new SelectListItem { value="DC", text="District Of Columbia"}); states.Add(new SelectListItem { value="FL", text="Florida"}); states.Add(new SelectListItem { value="GA", text="Georgia"}); states.Add(new SelectListItem { value="HI", text="Hawaii"}); states.Add(new SelectListItem { value="ID", text="Idaho"}); states.Add(new SelectListItem { value="IL", text="Illinois"}); states.Add(new SelectListItem { value="IN", text="Indiana"}); states.Add(new SelectListItem { value="IA", text="Iowa"}); states.Add(new SelectListItem { value="KS", text="Kansas"}); states.Add(new SelectListItem { value="KY", text="Kentucky"}); states.Add(new SelectListItem { value="LA", text="Louisiana"}); states.Add(new SelectListItem { value="ME", text="Maine"}); states.Add(new SelectListItem { value="MD", text="Maryland"}); states.Add(new SelectListItem { value="MA", text="Massachusetts"}); states.Add(new SelectListItem { value="MI", text="Michigan"}); states.Add(new SelectListItem { value="MN", text="Minnesota"}); states.Add(new SelectListItem { value="MS", text="Mississippi"}); states.Add(new SelectListItem { value="MO", text="Missouri"}); states.Add(new SelectListItem { value="MT", text="Montana"}); states.Add(new SelectListItem { value="NE", text="Nebraska"}); states.Add(new SelectListItem { value="NV", text="Nevada"}); states.Add(new SelectListItem { value="NH", text="New Hampshire"}); states.Add(new SelectListItem { value="NJ", text="New Jersey"}); states.Add(new SelectListItem { value="NM", text="New Mexico"}); states.Add(new SelectListItem { value="NY", text="New York"}); states.Add(new SelectListItem { value="NC", text="North Carolina"}); states.Add(new SelectListItem { value="ND", text="North Dakota"}); states.Add(new SelectListItem { value="OH", text="Ohio"}); states.Add(new SelectListItem { value="OK", text="Oklahoma"}); states.Add(new SelectListItem { value="OR", text="Oregon"}); states.Add(new SelectListItem { value="PA", text="Pennsylvania"}); states.Add(new SelectListItem { value="RI", text="Rhode Island"}); states.Add(new SelectListItem { value="SC", text="South Carolina"}); states.Add(new SelectListItem { value="SD", text="South Dakota"}); states.Add(new SelectListItem { value="TN", text="Tennessee"}); states.Add(new SelectListItem { value="TX", text="Texas"}); states.Add(new SelectListItem { value="UT", text="Utah"}); states.Add(new SelectListItem { value="VT", text="Vermont"}); states.Add(new SelectListItem { value="VA", text="Virginia"}); states.Add(new SelectListItem { value="WA", text="Washington"}); states.Add(new SelectListItem { value="WV", text="West Virginia"}); states.Add(new SelectListItem { value="WI", text="Wisconsin"}); states.Add(new SelectListItem { value="WY", text="Wyoming"}); </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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