Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / AutoFilter Class / Enabled Property
Example


In This Topic
    Enabled Property (AutoFilter)
    In This Topic
    Gets or sets whether to enable the automatic filter. The default value is false.
    Syntax
    'Declaration
     
    Public Property Enabled As Boolean
    'Usage
     
    Dim instance As AutoFilter
    Dim value As Boolean
     
    instance.Enabled = value
     
    value = instance.Enabled
    public bool Enabled {get; set;}
    Example
    This example filters out items when typing in the combo cell.
    FarPoint.Web.Spread.AutoFilter afilter = new FarPoint.Web.Spread.AutoFilter();
    afilter.Enabled = true;
    afilter.MatchingSource = FarPoint.Web.Spread.FilterMatchingSource.AllColumns;
    afilter.MinPrefixLength = 1;
    afilter.MaxFilteredItem = 10;
    
    System.Data.DataSet ds = new System.Data.DataSet();
    System.Data.DataTable emp = new System.Data.DataTable("Employees");
    System.Data.DataTable div = new System.Data.DataTable("Division");
    emp.Columns.Add("LastName");
    emp.Columns.Add("FirstName");
    emp.Rows.Add(new Object[] { "Jones", "Marianne" });
    emp.Rows.Add(new Object[] { "Fieldes", "Anna" });
    emp.Rows.Add(new Object[] { "Johnson", "Anna" });
    div.Columns.Add("Section");
    div.Columns.Add("Specialty");
    div.Rows.Add(new Object[] { "Finance", "Taxes" });
    div.Rows.Add(new Object[] { "Mergers", "Legal" });
    ds.Tables.AddRange(new System.Data.DataTable[] { emp, div });
    FarPoint.Web.Spread.MultiColumnComboBoxCellType mccbct = new FarPoint.Web.Spread.MultiColumnComboBoxCellType();
    mccbct.DataSource = ds;
    mccbct.VerticalAlign = VerticalAlign.Top;
    mccbct.AutoFilter = afilter;
    FpSpread1.ActiveSheetView.Cells[0, 0].CellType = mccbct;
    Dim afilter As New FarPoint.Web.Spread.AutoFilter()
    afilter.Enabled = True
    afilter.MatchingSource = FarPoint.Web.Spread.FilterMatchingSource.AllColumns
    afilter.MinPrefixLength = 1
    afilter.MaxFilteredItem = 10
    
    Dim ds As New System.Data.DataSet()
    Dim emp As New System.Data.DataTable("Employees")
    Dim div As New System.Data.DataTable("Division")
    emp.Columns.Add("LastName")
    emp.Columns.Add("FirstName")
    emp.Rows.Add(New Object() {"Jones", "Marianne"})
    emp.Rows.Add(New Object() {"Fieldes", "Anna"})
    emp.Rows.Add(New Object() {"Johnson", "Anna"})
    div.Columns.Add("Section")
    div.Columns.Add("Specialty")
    div.Rows.Add(New Object() {"Finance", "Taxes"})
    div.Rows.Add(New Object() {"Mergers", "Legal"})
    ds.Tables.AddRange(New System.Data.DataTable() {emp, div})
    Dim mccbct As New FarPoint.Web.Spread.MultiColumnComboBoxCellType()
    mccbct.DataSource = ds
    mccbct.VerticalAlign = VerticalAlign.Top
    mccbct.AutoFilter = afilter
    FpSpread1.ActiveSheetView.Cells(0, 0).CellType = mccbct
    See Also