Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FilterColumnDefinitionCollection Class / Contains Method
Filter column definition for which to check the collection
Example


In This Topic
    Contains Method (FilterColumnDefinitionCollection)
    In This Topic
    Specifies whether the collection contains the specified filter column definition.
    Syntax
    'Declaration
     
    Public Overridable Function Contains( _
       ByVal fcd As FilterColumnDefinition _
    ) As Boolean
    'Usage
     
    Dim instance As FilterColumnDefinitionCollection
    Dim fcd As FilterColumnDefinition
    Dim value As Boolean
     
    value = instance.Contains(fcd)
    public virtual bool Contains( 
       FilterColumnDefinition fcd
    )

    Parameters

    fcd
    Filter column definition for which to check the collection

    Return Value

    true if the sheet is found in the collection; otherwise, false
    Example
    This example queries the collection.
    FarPoint.Web.Spread.NamedStyle instyle = new FarPoint.Web.Spread.NamedStyle(); 
    FarPoint.Web.Spread.NamedStyle outstyle = new FarPoint.Web.Spread.NamedStyle(); 
    instyle.BackColor = Color.Yellow; 
    outstyle.BackColor = Color.Aquamarine; 
    FarPoint.Web.Spread.FilterColumnDefinitionCollection fcdc = new FarPoint.Web.Spread.FilterColumnDefinitionCollection(); 
    FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences
    | FarPoint.Web.Spread.FilterListBehavior.Default); 
    FarPoint.Web.Spread.FilterColumnDefinition fcd1 = new FarPoint.Web.Spread.FilterColumnDefinition(2, FarPoint.Web.Spread.FilterListBehavior.Default);
    
    FarPoint.Web.Spread.FilterColumnDefinition fcd2 = new FarPoint.Web.Spread.FilterColumnDefinition(3); 
    fcdc.Insert(0, fcd); 
    fcdc.Insert(1, fcd1); 
    fcdc.Insert(2, fcd2); 
    FarPoint.Web.Spread.StyleRowFilter sf = new FarPoint.Web.Spread.StyleRowFilter(FpSpread1.ActiveSheetView, instyle, outstyle);
    
    
    foreach (FarPoint.Web.Spread.FilterColumnDefinition x in fcdc) 
    { 
     sf.AddColumn(x); 
    }
    
    Dim instyle As New FarPoint.Web.Spread.NamedStyle
    Dim outstyle As New FarPoint.Web.Spread.NamedStyle
    instyle.BackColor = Color.Yellow
    outstyle.BackColor = Color.Aquamarine
    
    Dim fcdc As New FarPoint.Web.Spread.FilterColumnDefinitionCollection
    Dim fcd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences
    Or FarPoint.Web.Spread.FilterListBehavior.Default)
    Dim fcd1 As New FarPoint.Web.Spread.FilterColumnDefinition(2, FarPoint.Web.Spread.FilterListBehavior.Default)
    Dim fcd2 As New FarPoint.Web.Spread.FilterColumnDefinition(3)
    fcdc.Insert(0, fcd)
    fcdc.Insert(1, fcd1)
    fcdc.Insert(2, fcd2)
    Dim sf As New FarPoint.Web.Spread.StyleRowFilter(FpSpread1.ActiveSheetView, instyle, outstyle)
    Dim x As FarPoint.Web.Spread.FilterColumnDefinition
    For Each x In fcdc
          sf.AddColumn(x)
    Next
    
    See Also