title: Combobox.Items.Add visual basic
body: <p>Well i have another problem again,so i have 2 comboboxes the first one is called client_number and the second one is order_number well i was trying to do the next when i select a client in the first combo the second loads the order_number that client done.
  MySql query is this: </p>
  
  <pre><code>SELECT 
  order.number
  FROM order,client 
  WHERE order.client_number=client.number and client.number=" &amp; ComboBox1.SelectedValue
  </code></pre>
  
  <p>When i run the program, the second combobox loads me the order_number but if the client have done more than one order,the order_number appear but just appear one <code>order_number</code> if the client done 2 order just appear one.What i can do?</p>
  
  <p>By the way thats the code</p>
  
  <pre><code>     Private Sub ComboBox3_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles ComboBox3.SelectedIndexChanged
      conexao.Open()
      Dim strsql As String, i As Integer = 0
      Dim o As Integer
      o = ComboBox2.SelectedValue
      strsql = "SELECT count(order.number),order.number FROM order,client WHERE order.client_number=client.number and client.number=" &amp; ComboBox3.SelectedValue
      sqlcom = New MySqlCommand(strsql, conexao)
      dr = sqlcom.ExecuteReader
      If Not dr.HasRows Then
          MsgBox("not find")
      Else
          dr.Read()
          ComboBox2.Items.Add(dr("order_number"))
          'TextBox10.Text = dr(0).ToString
      End If
      dr.Close()
      conexao.Close()
  
  End Sub
  </code></pre>
  
  <p>I was using a textbox to count the number order and is working perfectly the textbox but the combo doesnt load more than one order </p>