How do I filter a datagridview by keyword?

Question

I want search a keyword from a Textbox in access file with C# and DataGridView, my code is below but has problem with error "Missing operand";

BindingSource bs = new BindingSource();
bs.DataSource = dataGridView1.DataSource;
bs.Filter = "select * FROM book WHERE onvan like '*" + textBox1.Text + "*'";
dataGridView1.DataSource = bs;

Answer 1

You can't pass a complete select query as a filter for your bindingsource. Try this instead

bs.Filter = "onvan like '*" + textBox1.Text + "*'";

And check this link for more informations: BindingSource.Filter.