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


In This Topic
    LoadOnDemandMode Enumeration
    In This Topic
    Indicates the mode of loading the next rows (standard or in background).
    Syntax
    'Declaration
     
    Public Enum LoadOnDemandMode 
       Inherits System.Enum
    'Usage
     
    Dim instance As LoadOnDemandMode
    public enum LoadOnDemandMode : System.Enum 
    Members
    MemberDescription
    BackgroundIndicates that spread loads the next set of rows after a period of time or after the user scrolls to the row at the SheetView.LoadOffsetFromBottom position.
    StandardIndicates that spread only loads the next rows if after scrolling, there are no bottom rows that are hidden from the view.
    Example
    This example sets the LoadOnDemandMode 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.Sheets[0].LoadOnDemandMode = FarPoint.Web.Spread.LoadOnDemandMode.Background;
    FpSpread1.Sheets[0].LoadOnDemandTriggerMode = FarPoint.Web.Spread.LoadOnDemandTriggerMode.Timed;
    FpSpread1.Sheets[0].LoadOnDemandInterval = 1000; // after every second, perform load on demand 
    FpSpread1.Sheets[0].LoadOffsetFromBottom = 20; // this setting is meaningless in Timed 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.Sheets(0).LoadOnDemandMode = FarPoint.Web.Spread.LoadOnDemandMode.Background
    FpSpread1.Sheets(0).LoadOnDemandTriggerMode = FarPoint.Web.Spread.LoadOnDemandTriggerMode.Timed
    FpSpread1.Sheets(0).LoadOnDemandInterval = 1000 ' after every second, perform load on demand 
    FpSpread1.Sheets(0).LoadOffsetFromBottom = 20 ' this setting is meaningless in Timed trigger mode 
    End Sub
    Inheritance Hierarchy

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

    See Also