title: How to Populate combobox form oracle database?
body: <p>I am trying to populate a <code>combobox</code> form oracle database then according to
  the selected value from <code>combobox</code> I want to automatically fill <code>textbox1</code>, <code>textbox2</code> and <code>textbox3</code></p>
  
  <p>here is the code i am trying to use to fill the <code>combobox</code> but 
  first problem is that <code>combobox</code> loads empty 
  second i want to learn how to fill the other <code>textboxs</code> automatically </p>
  
  <p>please if anyone can help me or explain to me </p>
  
  <pre><code>    public void Fillcombobox()
      {
          string connstr = "data source=db;user id=user;password=pwd;";
          string cmdtxt = "select product_id, description from products";
  
          using (OracleConnection conn = new OracleConnection(connstr))
          using (OracleCommand cmd = new OracleCommand(cmdtxt,conn))
          {
              conn.Open();
              OracleDataReader dr;
              cmd.ExecuteReader();
              CB_PRODUCT_ID.DisplayMember = "product_id";
              CB_PRODUCT_ID.ValueMember = "description";
  
              while (dr.Read())
              {
                  // what should I d to fill other textboxs ?
                  TB_PRODUCTS.Text = ???;
              }
          }
  
      }
  
      private void CB_PRODUCT_ID_SelectedIndexChanged(object sender, EventArgs e)
      {
          Fillcombobox();
      }
  </code></pre>