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 dgvStagiaires,Databind() 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.

help en C#

Answers (4)