Spread for ASP.NET 7.0 Product Documentation
LoadOnDemandTriggerMode Enumeration
Example  See Also  Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : LoadOnDemandTriggerMode Enumeration


Glossary Item Box

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

Visual Basic (Declaration) 
Public Enum LoadOnDemandTriggerMode 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As LoadOnDemandTriggerMode
C# 
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.
C#Copy Code
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
}
VB.NETCopy Code
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

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.