title: set Datagirdviewcombobox column value in Vb.net
body: <p>I have datagrid with two datagridviewcombo column, one column is dynamic fill and one has fixed hardcoded values. 
  The problem is I can't set the value of dynamic GridViewComboBox, when I try to set it generates continues errors.</p>
  
  <blockquote>
    <p>System.FormateException: DataGridViewComboBoxCell Value is not valid.</p>
  </blockquote>
  
  <p>My code to load the grid is </p>
  
  <blockquote>
  <pre><code>   Dim dt As DataTable
      dt = GetDataTable("Select valuecol,displayCol From mytable")  'GetDataTable gives me datatable
      cmbAntibiotics.DataSource = dt
      cmbAntibiotics.DisplayMember = "Antibiotics"
      cmbAntibiotics.ValueMember = "AntibioticsID"
  </code></pre>
  </blockquote>
  
  <pre><code>    Dim Index As Integer
  
      Dim dgr As DataGridViewRow
      For Each dr As DataRow In dtFromDB.Rows 'This datatable is filled with database
          Index = dtFromDB.Rows.Count - 1
          GRDAntimicrobials.Rows.Add()
          GRDAntimicrobials.Rows(Index).Cells("cmbAntibiotics").Value = dr("AntibioticsID").ToString   'At this point it shows value (1,2,3) rather then showing its display members
          GRDAntimicrobials.Rows(Index).Cells("AntibioticsStatus").Value = dr("AntibioticsStatus").ToString
      Next
  </code></pre>
  
  <p>Pls help with me </p>