Infragistics logo
메뉴
.NET and JavaScript UI Controls
Version

ColumnFilters Property (UltraGridBand)

Column filters for filtering all the rows in this band. NOTE: They will apply only if the UltraGridOverride.RowFilterMode is set to AllRowsInBand.
Syntax
'Declaration
 
Public ReadOnly Property ColumnFilters As ColumnFiltersCollection
public ColumnFiltersCollection ColumnFilters {get;}
Remarks

UltraGridOverride.RowFilterMode must be set to AllRowsInBand in order for these column filetrs to take effect. If it's set to SiblingRowsOnly (which it resolves to by default) then column filers off the RowsCollection RowsCollection.ColumnFilters will take effect on the associated rows collection.

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.

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
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;

}
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also