Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / LoadOnDemandInterval Property
Example


In This Topic
    LoadOnDemandInterval Property
    In This Topic
    Gets or sets a period of time (in milliseconds) when spread loads the next set of rows.
    Syntax
    'Declaration
     
    Public Property LoadOnDemandInterval As Integer
    'Usage
     
    Dim instance As SheetView
    Dim value As Integer
     
    instance.LoadOnDemandInterval = value
     
    value = instance.LoadOnDemandInterval
    public int LoadOnDemandInterval {get; set;}
    Example
    This example sets the LoadOnDemandInterval property.
    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
    See Also