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;
}
}
