private void prodCombo_SelectedIndexChanged(object sender, EventArgs e) { // debugTxt.Text = prodCombo.SelectedValue.ToString() ; //GetItemsByCat(); GetItems(prodCombo.SelectedValue.ToString()); CompBox.Update(); CompBox.SelectedItem = null; CompBox.DataSource = ds; CompBox.DisplayMember = "name"; CompBox.ValueMember = "id"; }
void GetItemsByCat() {//загрузка объектов по фильтру категорий MySqlDataAdapter a; DataTable ds; try { a = new MySqlDataAdapter("SELECT id, name FROM component WHERE items_id = '" + prodCombo.SelectedValue.ToString() + "'", DBConnect.Conn); ds = new DataTable(); a.Fill(ds); CompBox.Update(); CompBox.SelectedItem = null; CompBox.DataSource = ds; CompBox.DisplayMember = "name"; CompBox.ValueMember = "id"; } catch (MySqlException ex)//Ошибки MySql { debugTxt.Text = ex.Message; } }