help en C#

Question

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

Vulpes · Answer

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 Srivastava · Answer

Use dgvStagiairesDatabind() after Datasource.

dany · Answer

I just use the DataGridView and BindingSource. must use DataTable to make it work? thank you

Vulpes · Answer

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.