title: how to load data to many comboboxes from 1 database?
body: <p>i had 2 <code>comboboxes</code> and i i get datasource for 1 table, but when select data form <code>combobox1</code> the <code>combobox2</code> also change same as <code>combobox1</code>, i want to select its with different value.</p>
  
  <pre><code>cn.Open()
      sql1 = "SELECT * FROM Table_Illness"
      Dim da = New SqlDataAdapter(sql1, cn)
      da.Fill(Dataset, "Table_Illness")
      beforillnessComboBox.DataSource = Dataset.Tables("Table_Illness")
      beforillnessComboBox.DisplayMember = ("Illness_Name")
      beforillnessComboBox.ValueMember = ("Illness_ID")
  
      afterillnessComboBox.DataSource = Dataset.Tables("Table_Illness")
      afterillnessComboBox.DisplayMember = ("Illness_Name")
      afterillnessComboBox.ValueMember = ("Illness_ID")
      cn.Close() 
  </code></pre>