help en C#

dany

hello,
I want to know how to search in datagridview and only BindingSource, I want when the user starts to enter a word in a TextBox the result shows how to dynamically ing the datagridview!
I tried it but nothing happens!

private void textBox_search_word_TextChanged(object sender, EventArgs e)
{
if (textBox_search_word.Text == string.Empty)
{
MyBindingSource.RemoveFilter();
}
else
{
MyBindingSource.Filter = string.Format("Name LIKE '*{0}*'", textBox_search_word.Text);
MydataGridView.DataSource = MyBindingSource;
}

}

Thank you in advance

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
It should work as long as the underlying data source is a DataSet, DataTable or DataView as the syntax for the filter expression is built into these classes. See the Remarks in this link:

http://msdn.microsoft.com/en-us/library/system.windows.forms.bindingsource.filter.aspx

If your BindingSource is just a collection of objects, then it probably won't work so you'd need to convert it to a DataTable first.
Abhineet Srivastava13y ago
Use
dgvStagiaires,Databind() after Datasource.
dany13y ago
I just use the DataGridView and BindingSource.
must use DataTable to make it work?
thank you
Vulpes13y ago
As long as the underlying data source is a DataSet, DataTable or DataView then the code looks to me like it should work and did so when I tried a simple example just now.

I assume that 'Nom' is in fact a valid column name and that leading/trailing spaces or case sensitivity (turned off by default) are not potential issues.

If you have a large number of rows in the data source, then response speed could be a problem as the DGV is being rebound (and hence redrawn) as each character is typed.

However, you should be able to remove this line:

dgvStagiaires.DataSource = bsStagiaires;

because just changing the Filter property should be enough to cause the DGV to redraw.