本文介绍了如何使用 ComboBox 过滤 DataGridView的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要帮助使用 ComboBox 过滤我的 DataGridView
I need help on filtering my DataGridView using ComboBox
这是我的显示代码
cm = new SqlCommand(); cn = new SqlConnection(lgn.connections); cn.Open(); cm.Connection = cn; query = "Select * from Trails"; cm.CommandText = query; SqlDataAdapter dar = new SqlDataAdapter(cm); DataTable dt = new DataTable(); dar.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.Columns[0].Width = 0; dataGridView1.Columns[1].Width = 130; dataGridView1.Columns[2].Width = 100; dataGridView1.Columns[3].Width = 360; dataGridView1.Columns[4].Width = 130; this.dataGridView1.Columns[0].Visible = false;原始数据:
ID | TRANSACTYPE | DESCRIPTION | AUTHORIZED BY ----------------------------------------------- 1 | LOGIN | blah blah | BOB 2 | LOGOUT | blah blah | BOB 3 | LOGIN | blah blah | TIM 4 | LOGOUT | blah blah | KURT我有名为 cboFilter 的 ComboBox,如果我将索引更改为 LOGIN,数据将显示在 dataGridView1代码>只是登录.
I have ComboBox named cboFilter and if I changed the index to LOGIN the data that will show on the dataGridView1 is only LOGINs.
推荐答案试试这个:
DataTable dt = new DataTable(); private void cboFilter_SelectedIndexChanged(object sender, EventArgs e) { DataView dv = dt.DefaultView; dv.RowFilter = string.Format("TRANSACTYPE LIKE '%{0}%'", cboFilter.SelectedItem.ToString()); dataGridView1.DataSource = dv; }更多推荐
如何使用 ComboBox 过滤 DataGridView
发布评论