使用组合框选择项筛选datagridview [英] filter datagridview with combobox selected item

问题描述

我有问题我这个代码请帮帮我。它显示的是lenth而不是实际值..................

i have have problem i this code please help me . it show the lenth not the actual value..................

try 

            {

            SqlCommand cmd = new SqlCommand(" select bond_no from bond_data_entry where denom='" + Convert.ToString(denom_comboBox.SelectedItem) + "'", db.cn);
            SqlDataReader dr = cmd.ExecuteReader();
            var list = new List<string>();
            while (dr.Read())
            {
                //list.Add(dr["bond_no"].ToString());
                list.Add(dr.GetValue(5).ToString());

            }
            //SqlDataAdapter da = new SqlDataAdapter();
            //DataSet ds = new DataSet();
            dataGridView1.DataSource = list;

            dr.Close();
             }
            catch (Exception e1)
            {
                MessageBox.Show("Error in Db=" + e1.Message);
            }

推荐答案

更改此行： -

Change this row:-

SqlCommand cmd = new SqlCommand(" select bond_no from bond_data_entry where denom='" + Convert.ToString(denom_comboBox.SelectedItem.Value) + "'", db.cn);

或

Or

SqlCommand cmd = new SqlCommand(" select bond_no from bond_data_entry where denom='" + Convert.ToString(denom_comboBox.SelectedValue) + "'", db.cn);

(dataGridView1.DataSource as DataTable).DefaultView.RowFilter = string.Format("denom= '{0}'", denom_comboBox.SelectedItem);

这是我解决它的简单路线我自己谢谢大家......：）

this was the simple line i have solve it my self thankx everyone... :)

这篇关于使用组合框选择项筛选datagridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！