title: How to bind LINQ data to dropdownlist
body: <p>The last two lines of this code do not work correctly -- the results are coming back from the LINQ query.  I'm just not sure how to successfully bind the indicated columns in the results to the textfield and valuefield of the dropdownlist:</p>
  
  <pre><code>    protected void BindMarketCodes()
      {
          List&lt;lkpMarketCode&gt; mcodesList = new List&lt;lkpMarketCode&gt;();
  
          LINQOmniDataContext db = new LINQOmniDataContext();
  
          var mcodes = from p in db.lkpMarketCodes 
                          orderby 0
                          select p;
  
          mcodesList = mcodes.ToList&lt;lkpMarketCode&gt;();
  
          //bind to Country COde droplist
          dd2.DataSource = mcodesList;
          dd2.DataTextField = mcodesList[0].marketName;
          dd2.DataValueField = mcodesList[0].marketCodeID.ToString();
  
      }
  </code></pre>