ComboBox二次更新文本失效问题求助（首次更新正常）

• 对ComboBox执行两次更新操作：
  1. 当另一个ComboBox选中时，为其填充描述信息，此功能正常；
  2. 选中下拉菜单中的描述后，将自身文本更新为对应价格，控制台输出的价格值正确，但ComboBox文本未更新。
• ComboBox模式为DropDown，已尝试移除重建控件、修改索引等方法，问题仍存在。

private Dictionary<string, string> prezziDictionary = new Dictionary<string, string>();

private void comboBox9_SelectedIndexChanged(object sender, EventArgs e)
{
    string selectedArticolo = comboBox9.Text;

    if (!string.IsNullOrEmpty(selectedArticolo))
    {
        PopulateComboBox1(selectedArticolo);
    }
}

private void PopulateComboBox1(string selectedArticolo)
{
    try
    {
        using (MySqlConnection con = new MySqlConnection(Form1.credentials))
        {
            con.Open();
            string query = "SELECT descrizione, prezzo FROM prezzi_articoli WHERE articolo = @articolo";
            using (MySqlCommand cmd = new MySqlCommand(query, con))
            {
                cmd.Parameters.AddWithValue("@articolo", selectedArticolo);

                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    comboBox1.Items.Clear();

                    prezziDictionary.Clear();

                    while (reader.Read())
                    {
                        string descrizione = reader["descrizione"].ToString();
                        comboBox1.Items.Add(descrizione);

                        string prezzo = reader["prezzo"].ToString();
                        prezziDictionary[descrizione] = prezzo;
                    }
                }
            }
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show("Error: " + ex.Message);
    }
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    string selectedDescrizione = comboBox1.Text;

    if (!string.IsNullOrEmpty(selectedDescrizione))
    {
        if (prezziDictionary.TryGetValue(selectedDescrizione, out string prezzo))
        {
            comboBox1.Text = prezzo;
            Console.WriteLine("b " + prezzo);
        }
        else
        {
            MessageBox.Show("Prezzo not found for selected description.");
        }
    }
}

核心原因 #

在comboBox1_SelectedIndexChanged事件中设置comboBox1.Text = prezzo时，该操作会再次触发SelectedIndexChanged事件（文本改变会导致选中索引重置为-1），后续事件执行会覆盖刚设置的文本值，最终导致界面无法显示价格更新。同时DropDown模式下，直接修改Text属性若与Items项不匹配，控件内部逻辑也会干扰赋值操作。

解决方法 #

方法一：临时禁用事件触发

修改文本前先取消事件绑定，完成后重新绑定，避免事件重入：

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    string selectedDescrizione = comboBox1.Text;

    if (!string.IsNullOrEmpty(selectedDescrizione))
    {
        if (prezziDictionary.TryGetValue(selectedDescrizione, out string prezzo))
        {
            // 移除事件处理
            comboBox1.SelectedIndexChanged -= comboBox1_SelectedIndexChanged;
            comboBox1.Text = prezzo;
            // 重新绑定事件
            comboBox1.SelectedIndexChanged += comboBox1_SelectedIndexChanged;
            Console.WriteLine("b " + prezzo);
        }
        else
        {
            MessageBox.Show("Prezzo not found for selected description.");
        }
    }
}

方法二：使用BeginInvoke延迟执行修改

利用UI线程消息队列延迟修改操作，避开事件重入的时机：

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    string selectedDescrizione = comboBox1.Text;

    if (!string.IsNullOrEmpty(selectedDescrizione))
    {
        if (prezziDictionary.TryGetValue(selectedDescrizione, out string prezzo))
        {
            comboBox1.BeginInvoke(new Action(() => {
                comboBox1.Text = prezzo;
            }));
            Console.WriteLine("b " + prezzo);
        }
        else
        {
            MessageBox.Show("Prezzo not found for selected description.");
        }
    }
}

方法三：封装数据类优化逻辑

将描述和价格封装为类作为ComboBox的Item，避免字典映射的潜在问题，逻辑更清晰：

// 定义数据类
public class ArticoloPrezzo
{
    public string Descrizione { get; set; }
    public string Prezzo { get; set; }
    // 下拉菜单显示描述
    public override string ToString() => Descrizione;
}

// 修改PopulateComboBox1方法
private void PopulateComboBox1(string selectedArticolo)
{
    try
    {
        using (MySqlConnection con = new MySqlConnection(Form1.credentials))
        {
            con.Open();
            string query = "SELECT descrizione, prezzo FROM prezzi_articoli WHERE articolo = @articolo";
            using (MySqlCommand cmd = new MySqlCommand(query, con))
            {
                cmd.Parameters.AddWithValue("@articolo", selectedArticolo);
                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    comboBox1.Items.Clear();
                    while (reader.Read())
                    {
                        comboBox1.Items.Add(new ArticoloPrezzo
                        {
                            Descrizione = reader["descrizione"].ToString(),
                            Prezzo = reader["prezzo"].ToString()
                        });
                    }
                }
            }
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show("Error: " + ex.Message);
    }
}

// 修改SelectedIndexChanged事件
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    var selectedItem = comboBox1.SelectedItem as ArticoloPrezzo;
    if (selectedItem != null)
    {
        comboBox1.SelectedIndexChanged -= comboBox1_SelectedIndexChanged;
        comboBox1.Text = selectedItem.Prezzo;
        comboBox1.SelectedIndexChanged += comboBox1_SelectedIndexChanged;
    }
}

内容的提问来源于stack exchange，提问作者Andre5820