仅在按下向下键时才能获得Combobox selectedValue [英] Only able to get Combobox selectedValue when down key is pressed

问题描述

我已经制作了WPF自动完成组合框，而我所面临的问题是，当我按下向下键时，我只能获得ComboBox的SelectedValue.

I have made a WPF Autocomplete Combobox, and the problem which i am facing is that i am only able to get SelectedValue of ComboBox when i press Down Key.

问题在BindComboBox方法下面，而comboBox5.SelectedValue仅在按下向下键时起作用.

Problem is in below BindComboBox Method, and comboBox5.SelectedValue only works when down Key is pressd.

 public void BindComboBox3(ComboBox comboBox3) //BatchCombobox
    {
        SqlDataAdapter da = new SqlDataAdapter("Select id,batch_id FROM batch where product_id_fk='" + Convert.ToInt32(comboBox5.SelectedValue) + "' and left_qty>0", con);
        DataSet ds = new DataSet();
        da.Fill(ds, "batch");
        comboBox3.ItemsSource = ds.Tables[0].DefaultView;
        comboBox3.DisplayMemberPath = ds.Tables[0].Columns["batch_id"].ToString();
        comboBox3.SelectedValuePath = ds.Tables[0].Columns["id"].ToString();
    }

但是在下面的代码中，comboBox5.SelectedValue正常工作.

But in Below code comboBox5.SelectedValue is properly Working.

private void comboBox5_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {

        comboBox3.IsEnabled = true;
        BindComboBox3(comboBox3); //Problem is in this Function

        con.Open();
        SqlCommand cmd1 = new SqlCommand("SELECT med_type,fk_com_id FROM products where p_id_pk='" + Convert.ToInt32(comboBox5.SelectedValue) + "'", con);

        SqlDataReader med_oftype = null;

        med_oftype = cmd1.ExecuteReader();

        while (med_oftype.Read())
        {
            get_med_type = med_oftype["med_type"].ToString();
            cmpny_id = Convert.ToInt32(med_oftype["fk_com_id"]);
        }

        con.Close(); 

    }

private void ProductsComboBox_TextChanged(object sender, TextChangedEventArgs e)
    {
        if (((ComboBox)sender).Text != "")
        {
            SqlDataAdapter da = new SqlDataAdapter("Select p_id_pk,p_name FROM products", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "products");
            comboBox5.ItemsSource = ds.Tables[0].DefaultView.RowFilter = "p_name like '" + ((ComboBox)sender).Text + "'+'%'";
            comboBox5.ItemsSource = ds.Tables[0].DefaultView;
            comboBox5.DisplayMemberPath = ds.Tables[0].Columns["p_name"].ToString();
            comboBox5.SelectedValuePath = ds.Tables[0].Columns["p_id_pk"].ToString();
        }
        else
        {
            comboBox5.ItemsSource = null;
        }
    } 

摘要是，在一个事件处理程序中，comboBox5.SelectedValue工作正常，而在另一个comboBox5.SelectedValue中，工作异常正常.不知道是什么原因导致此问题.

Summary is that in one event handler comboBox5.SelectedValue is working and in other comboBox5.SelectedValue is not working. Dont know what is causing this problem.

推荐答案

• 如果您可以共享.xaml代码，这将很有帮助
• 还可以澄清为什么发送( comboBox3 )作为参数的原因尽管可以在视图中的任何位置访问它
• 作为一种快速解决方案，您可以将 SelectedValue 作为参数传递给 BindComboBox3 方法
• if you can share your .xaml code this would be helpful
• also if you can clarify why you send (comboBox3) as a parameter although it is accessible any where in the view
• as a quick solution you can pass SelectedValue as a parameter to BindComboBox3 method

这篇关于仅在按下向下键时才能获得Combobox selectedValue的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！