Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / LoadOnDemandTriggerMode Enumeration
Example Example


In This Topic
    LoadOnDemandTriggerMode Enumeration
    In This Topic
    Specifies the method for loading the next set of rows (after a period of time or after the user scrolls to the row at the SheetView.LoadOffsetFromBottom position).
    Syntax
    'Declaration
     
    Public Enum LoadOnDemandTriggerMode 
       Inherits System.Enum
    'Usage
     
    Dim instance As LoadOnDemandTriggerMode
    public enum LoadOnDemandTriggerMode : System.Enum 
    Members
    MemberDescription
    OffsetBasedIndicates that spread only loads the next set of rows after the user scrolls to the row at the SheetView.LoadOffsetFromBottom position.
    TimedIndicates that spread loads the next set of rows after a period of time.
    Example
    This example sets the LoadOnDemandTriggerMode enumeration.
    protected void Page_Load(object sender, System.EventArgs e)
    {
    FpSpread1.ActiveSheetView.RowCount = 100;
    FpSpread1.ActiveSheetView.PageSize = 200;
    FpSpread1.ActiveSheetView.AllowPage = false;
    
    FpSpread1.AllowLoadOnDemand = true;
    FpSpread1.LoadInitRowCount = 50;
    FpSpread1.LoadRowIncrement = 15;
    FpSpread1.ActiveSheetView.LoadOnDemandMode = FarPoint.Web.Spread.LoadOnDemandMode.Background;
    FpSpread1.ActiveSheetView.LoadOnDemandTriggerMode = FarPoint.Web.Spread.LoadOnDemandTriggerMode.OffsetBased;
    FpSpread1.ActiveSheetView.LoadOffsetFromBottom = 20;
    FpSpread1.ActiveSheetView.LoadOnDemandInterval = 1000; // this setting is meaningless in OffsetBased trigger mode
    }
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    FpSpread1.ActiveSheetView.RowCount = 100
    FpSpread1.ActiveSheetView.PageSize = 200
    FpSpread1.ActiveSheetView.AllowPage = False
    
    FpSpread1.AllowLoadOnDemand = True
    FpSpread1.LoadInitRowCount = 50
    FpSpread1.LoadRowIncrement = 15
    FpSpread1.ActiveSheetView.LoadOnDemandMode = FarPoint.Web.Spread.LoadOnDemandMode.Background
    FpSpread1.ActiveSheetView.LoadOnDemandTriggerMode = FarPoint.Web.Spread.LoadOnDemandTriggerMode.OffsetBased
    FpSpread1.ActiveSheetView.LoadOffsetFromBottom = 20
    FpSpread1.ActiveSheetView.LoadOnDemandInterval = 1000 ' this setting is meaningless in OffsetBased trigger mode
    End Sub
    Inheritance Hierarchy

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

    See Also