title: How can I add a Combobox column to a GridControl?
body: <p>I have a grid control that loads data from a DataBase in a desktop Windows Forms application. But I also need a new local column with a combobox (with some items) that when I click it it save the information into another table of the database.
  <a href="https://i.stack.imgur.com/CeUIr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CeUIr.png" alt="enter image description here"></a>
  <br>
  This is my code</p>
  
  <pre><code>            DataTable dt = new DataTable();
              string conStr = @"Data Source =...;Initial Catalog=...; Integrated Security=true;";
              SqlConnection con = new SqlConnection(conStr);
              SqlCommand com = new SqlCommand("SPS_PronosticoStock2", con);
              com.Parameters.AddWithValue("@IdProducto", Convert.ToInt32(textBox3.Text));
              com.Parameters.AddWithValue("@IdBodega", Convert.ToInt32(textBox4.Text));
              com.Parameters.AddWithValue("@FechaInicio", dateTimePicker1.Value);
              com.Parameters.AddWithValue("@FechaFin", dateTimePicker2.Value);
              com.CommandType = CommandType.StoredProcedure;
              SqlDataAdapter da = new SqlDataAdapter(com);
              try
              {
                  con.Open();
                  da.Fill(dt);
              }
              catch (Exception)
              {
                  throw;
              }
              finally
              {
                  if (con.State == ConnectionState.Open)
  
                      con.Close();
              }      
              gridControl1.DataSource = dt;
  </code></pre>
  
  <p>I tried a combobox edit but when i click the items they disappear and nothing is edited, please someone help me with this. </p>