'Declaration Public Property RowFilterMode As RowFilterMode
public RowFilterMode RowFilterMode {get; set;}
This property determines determines whether row filtering is done at the band level or individual rows collection level. If this property is set to AllRowsInBand then when the user selects a filter criteria all row islands in that band are applied that filer. If the property is set to SiblingRowsOnly then the filter criteria is only applied to the current row island.
NOTE: This property affects how you specify filter criteria in code. If this property is set to AllRowsInBand then you must use UltraGridBand's ColumnFilters property (UltraGridBand.ColumnFilters). If this property is set to SiblingRowsOnly then you must use the RowsCollection's ColumnFilters (RowsCollection.ColumnFilters) property.
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; }
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