Infragistics(R) NetAdvantage(R) Windows Forms
FilterCondition Class
Members  Example  See Also  E-mail your feedback on this topic.
Infragistics.Win.UltraWinGrid Namespace : FilterCondition Class

Class used for defining a row filter condition.

Syntax

Visual Basic (Declaration) 
Public Class FilterCondition 
   Inherits Infragistics.Shared.SubObjectBase
C# 
public class FilterCondition : Infragistics.Shared.SubObjectBase 

Example

Following code shows how to enable row filtering as well as filter rows in code. It adds multiple conditions on a single column to filter rows. It shows only rows with Unit Price greater than 5 and less than 10.

Visual BasicCopy Code
Imports Infragistics.Shared
Imports Infragistics.Win
Imports Infragistics.Win.UltraWinGrid

  Private Sub Button10_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles button10.Click

      Dim band As UltraGridBand = Me.UltraGrid1.DisplayLayout.Bands(2)

      ' Set AllowRowFiltering to true to allow the user to filter rows. This is not
      ' necessary for filtering rows through code.
      band.Override.AllowRowFiltering = DefaultableBoolean.True

      ' You can enable or disable row filtering on individual columns too.
      ' Column's setting have higher precedence for that column than the band's
      ' override settings.
      band.Columns("Phone").AllowRowFiltering = DefaultableBoolean.False

      ' Set the RowFilterMode off the override to AllRowsInBand so that the
      ' ultragrid makes use of UltraGridBand.ColumnFilters.
      band.Override.RowFilterMode = RowFilterMode.AllRowsInBand

      ' Clear any previous filters on that column.
      band.ColumnFilters("Unit Price").FilterConditions.Clear()

      ' Add two conditions one that requires value be greater than 5 and another
      ' that requires that the value be less than 10. Also we want to And these
      ' conditions because the value must satisfy both conditions. To do that
      ' set the LogicalOperator on the ColumnFilter of that column to And.
      band.ColumnFilters("Unit Price").FilterConditions.Add(FilterComparisionOperator.GreaterThan, 5)
      band.ColumnFilters("Unit Price").FilterConditions.Add(FilterComparisionOperator.LessThan, 10)
      band.ColumnFilters("Unit Price").LogicalOperator = FilterLogicalOperator.And

  End Sub
C#Copy Code
using Infragistics.Shared;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System.Diagnostics;

private void button10_Click(object sender, System.EventArgs e)
{

	UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[2];

	// Set AllowRowFiltering to true to allow the user to filter rows. This is not
	// necessary for filtering rows through code.
	band.Override.AllowRowFiltering = DefaultableBoolean.True;

	// You can enable or disable row filtering on individual columns too.
	// Column's setting have higher precedence for that column than the band's
	// override settings.
	band.Columns["Phone"].AllowRowFiltering = DefaultableBoolean.False;

	// Set the RowFilterMode off the override to AllRowsInBand so that the
	// ultragrid makes use of UltraGridBand.ColumnFilters.
	band.Override.RowFilterMode = RowFilterMode.AllRowsInBand;

	// Clear any previous filters on that column.
	band.ColumnFilters["Unit Price"].FilterConditions.Clear( );

	// Add two conditions one that requires value be greater than 5 and another
	// that requires that the value be less than 10. Also we want to And these
	// conditions because the value must satisfy both conditions. To do that
	// set the LogicalOperator on the ColumnFilter of that column to And.
	band.ColumnFilters["Unit Price"].FilterConditions.Add( FilterComparisionOperator.GreaterThan, 5 );
	band.ColumnFilters["Unit Price"].FilterConditions.Add( FilterComparisionOperator.LessThan, 10 );
	band.ColumnFilters["Unit Price"].LogicalOperator = FilterLogicalOperator.And;

}

Remarks

A FilterCondition object defines a single condition. Multiple FilterCondition instances can be added to the FilterConditionsCollection. A ColumnFilter instance contains a FilterConditionsCollection instance. The ColumnFilter has LogicalOperator property which specifies how multiple conditions contained in the ColumnFilter's FilterConditionCollection are to be combined. A ColumnFiltersCollection can contain multiple ColumnFilter instances. Both the UltraGridBand and RowsCollection objects expose ColumnFilters property. This property returns a collection of ColumnFilter objects. UltraGrid will filter rows using either the RowsCollection's RowsCollection.ColumnFilters or UltraGridBand's UltraGridBand.ColumnFilters depending on the what the Override's UltraGridOverride.RowFilterMode property is set to. See UltraGridOverride.RowFilterMode for more information.

See Also