在datagridview中过滤数据C＃ [英] Filter data in datagridview c#

问题描述

我正在尝试过滤出我想要的数据，并隐藏所有其他数据。
这是我的代码列表，

i am trying to filter out the data that i want, and hide all the other data instead. Here is my list of code,

private void searchButton_Click_1(object sender, EventArgs e)
        {

            BindingSource bs = new BindingSource();
            bs.DataSource = dataGridView1.DataSource;
            bs.Filter = dataGridView1.Columns[1].HeaderText.ToString() + " LIKE '%" +  searchTextBox.Text + "%'";
            dataGridView1.DataSource = bs;

        }

但是当我运行它时，它提示我错误消息

but when i run it, it prompts me error message

在'ID'运算符之后缺少操作数。

"Missing operand after 'ID' operator."

我也尝试过此错误消息。

and i have tried this too, same error message.

private void searchButton_Click_1(object sender, EventArgs e)
        {
            BindingSource bs = new BindingSource();
            bs.DataSource = dataGridView1.DataSource;
           // bs.Filter = dataGridView1.Columns[1].HeaderText.ToString() + " LIKE '%" + searchTextBox.Text + "%'";
            bs.Filter = "Sample ID like '*" + searchTextBox.Text + "*'";
            dataGridView1.DataSource = bs;
        }

任何人都可以帮助我阐明问题吗？

can anyone please help me clarify the problem? thanks.

推荐答案

尝试以下方法，

BindingSource bs = new BindingSource();
bs.DataSource = dataGridView1.DataSource;
bs.Filter = "yourColumnName like '%" + textBox1.Text + "%'";
dataGridView1.DataSource = bs;

或

在搜索文本框中已更改事件，请尝试以下操作，

In Search Text Box Changed event, try the following,

(dataGridView1.DataSource as DataTable).DefaultView.RowFilter = string.Format("Field = '{0}'", searchTextBox.Text);

这篇关于在datagridview中过滤数据C＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！