Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / DatePickerMode Enumeration
Example Example


In This Topic
    DatePickerMode Enumeration
    In This Topic
    Specifies how to display the DatePicker control in the filter bar.
    Syntax
    'Declaration
     
    Public Enum DatePickerMode 
       Inherits System.Enum
    'Usage
     
    Dim instance As DatePickerMode
    public enum DatePickerMode : System.Enum 
    Members
    MemberDescription
    AutoShows or hides the DatePicker control based on the type of data in the column. If the drop-down button is not displayed, the date picker button is not displayed.
    HideHides the DatePicker control in the filter bar.
    ShowShows the DatePicker control in the filter bar.
    Example
    This example sets the DatePickerMode enumeration.
    protected void Page_Load(object sender, EventArgs e)
    {
    if (this.IsPostBack) return;
    FarPoint.Web.Spread.DateTimeCellType dt = new FarPoint.Web.Spread.DateTimeCellType();
    System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
    dtf.LongDatePattern = "D";
    dtf.ShortDatePattern = "M/d/yyyy";
    dt.DateTimeFormat = dtf;
    FpSpread1.Sheets[0].Cells[0, 0, 0, 2].CellType = dt;
    FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;
    
    FarPoint.Web.Spread.FilterBarCellType fbcell = new FarPoint.Web.Spread.FilterBarCellType(true);
    fbcell.DatePickerMode = FarPoint.Web.Spread.DatePickerMode.Auto;
    
    FpSpread1.Sheets[0].RowCount = 6;
    FpSpread1.Sheets[0].ColumnCount = 6;
    //Customize "Cells" in Filter Bar
    FarPoint.Web.Spread.SheetView sheetView = FpSpread1.ActiveSheetView;
    sheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar;  
    sheetView.FilterBar.Cells[0].CellType = fbcell;
    sheetView.FilterBar.Cells[0].BackColor = System.Drawing.Color.Aqua;
    }
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load
    If (IsPostBack) Then
        Return
    End If
    Dim dt As New FarPoint.Web.Spread.DateTimeCellType()
    Dim dtf As New System.Globalization.DateTimeFormatInfo()
    dtf.LongDatePattern = "D"
    dtf.ShortDatePattern = "M/d/yyyy"
    dt.DateTimeFormat = dtf
    FpSpread1.Sheets(0).Cells(0, 0, 0, 2).CellType = dt
    FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now
    
    Dim fbcell As New FarPoint.Web.Spread.FilterBarCellType(True)
    fbcell.DatePickerMode = FarPoint.Web.Spread.DatePickerMode.Auto
    
    FpSpread1.Sheets(0).RowCount = 6
    FpSpread1.Sheets(0).ColumnCount = 6
    'Customize "Cells" in Filter Bar
    Dim sheetView As FarPoint.Web.Spread.SheetView = FpSpread1.ActiveSheetView
    sheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar
    sheetView.FilterBar.Cells(0).CellType = fbcell
    sheetView.FilterBar.Cells(0).BackColor = System.Drawing.Color.Aqua
    End Sub
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Web.Spread.DatePickerMode

    See Also