title: Binding ComboBox to 2 DataSource: Table & Enum
body: <p>I have the next Enum:</p>
  
  <pre><code>public enum DoneStatus
  {
      empty=0,
      succeed,
      failed
  };
  </code></pre>
  
  <p>and the table <em>StatusTbl</em> with the column <em>MyStatus</em> which contain 0 / 1 / 2.</p>
  
  <p>How can I display this information in a DataGridViewComboBoxColumn?</p>
  
  <p>I tried to write the next:</p>
  
  <pre><code>ComboColumn.DataSource = Enum.GetValues(typeof(DoneStatus));
  ComboColumn.DataPropertyName = "DoneStatus";
  ComboColumn.Name = "DoneStatus";
  </code></pre>
  
  <p>but I can see only all the options in the combo, I can't see the right selected value according to the value in the table.</p>
  
  <p>I also tried to connect the combo a binding souce:</p>
  
  <pre><code>ComboColumn.DataSource = statusTblBindingSource;
  ComboColumn.DataPropertyName = "MyStatus";
  </code></pre>
  
  <p>But then I only saw the int values (0/1/2) and not the string values.</p>
  
  <p>Which DataSource should I use? </p>
  
  <p>How can I combine between the DB and the enum in the data source?</p>