Revision: 54938
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at January 18, 2012 21:58 by codernet
Initial Code
if (txtSearchTextBox.Text != string.Empty) { DataView dvNewDataViewObject = new DataView(); dvNewDataViewObject.Table = AnyDataset.AnyDataTableInsideIt; dvNewDataViewObject.RowFilter = "[AnyColumnOfDataTable] LIKE " + "'%" + txtSearchTextBox.Text + "%'"; DataGridViewControl.DataSource = dvNewDataViewObject; DataGridViewControlOnForm.Refresh(); } else { DataGridViewControlOnForm.DataSource = ActualorAnyBindingSource; ActualorAnyAdapter.Fill(AnyDataset.AnyDataTableInsideIt); DataGridViewControlOnForm.Refresh(); }
Initial URL
Initial Description
The above snippet can be used in any EventHandler such as TextChanged to Filter/Search a DataBound DataGridView according to a search term. When the TextBox from which the search parameter is taken will be empty the original DataGridViewRows will be filled. The RowFilter Propery can be given other SQL compatible operators such as >,<,<=
Initial Title
Filter a DataGridView
Initial Tags
Initial Language
C#