Return to Snippet

Revision: 54938
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#